bulk copy to Excel

[Ben]

Hi all,

I have Access and Excel 2003. I have a query that returns about 3K
rows. When the query returns the records, I can do a bulk copy by right
clicking on the upper left corner and select copy and just paste the
entire recordset onto Excel. Is there a way to do that in code rather
than writing out each record field-by-field? There's about 50 fields and
it takes way too long. Please show me a code snippet to accomplish this
task. Thanks in advance for sharing your thoughts.


Ben

 

[Douglas J. Steele]

Look at the TransferSpreadsheet method. You can specify the query name
rather than a table name.

 

[ryguy7272]

This is a GREAT resource:
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm

These two are probably most relevant to your post:
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#FilterExportSepFiles
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#FilterExportSameFile