Import records from Access into Excel

[CBO]

Does anyone know some code to return records from Access to an Excel Spreadsheet?

 

[CBO]

Still need help getting records from Access into Excel. Anyone know any VBA code??

 

[mresann]

Here's some code you may look at. It also includes creating a chart in Powerpoint.

 

[ghudson]

The TransferSpreadsheet method will output data [table or query] to an Excel file.

 

[CBO]

Re: Get records from Access into Excel

mresann,

can't open the database, what version of access is it in?

 

[CBO]

Re: Get Access Records into Excel

ghudson

thanks, i will try the transfer spreadsheet.

 

[rglman]

This is the basic code..

DoCmd.TransferSpreadsheet acExport, 8, "qryYourQuery", "\\YourPath\YourFile.xls", False, ""

 

[mresann]

mresann,

can't open the database, what version of access is it in?

Office 2003.