Export data to Excel

[smiler]

Hi All,
As part of an Access Database project I am working on right now, there is an urgent need for some of the data to be exported to excel. The data is already in Access tables and I already have select queries which brings up the data. Because the data from the queries will be analyzed with other statistical software, I will be grateful if any one can help me with any ideas or code for creating the excel sheet and writing the results of the select query into the excel worksheets. Thank you.

 

[jleach]

Hi,

If you already have a query which selects the correct data, getting it to excel is easy.

Check help/intellisense on the following VBA method:
DoCmd.TransferSpreadsheet

Should be pretty self explainitory

hth