Exporting data to Excel

[adwaitjoshi]

I am generating a query on the fly.Then I use the recordSet object to get the "SELECT" query results. I want to export these results from VBA to Excel.Could someone please tell me how to do this.
Thank you

 

[jjturner]

Lookup TransferSpreadsheet action/method in Access help.

 

[adwaitjoshi]

Can I transfer the recordset object using the Transfer Spreadsheet command.I am only aware of Transfer Spreadsheet command transfering tables.

 

[jjturner]

It can also Transfer Select queries, as indicated in the Help file. Just provide the name of your query in the argument for table name.