Exporting results from access to Excel in VBA

[phillysri]

hi

I am trying to export the result from a query into an excel . Could you tell me how to do this ..

thanks

 

[PHV]

Have a look at the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[phillysri]

Thanks a lot PHV I have tried this statement but it is giving me an error for the table name says microsoft JET could not find this object name

Where do we need to create this table ...in access or VBA

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "table1", "C:\Documents and Settings\TaduriS\My Documents\File.xls", True


thanks

 

[PHV]

Replace table1 with the name of the query you want to export.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[phillysri]

Hi PHV

I have created a variable with the the query in it and used that query to export but still it is giving an error saying object or path not found.

what path we need to give for this ?