bulk copy to Excel

  • Thread starter Thread starter Ben
  • Start date Start date
B

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
 
Look at the TransferSpreadsheet method. You can specify the query name
rather than a table name.
 
Back
Top