Use the TransferSpreadsheet method. The easiest way to do it is to create a
Macro, select the TransferSpreadsheet Action, fill in the information. Copy
this action as many times as you need. Change the name of the Query to be
transfered in each line, but leave the workbook name the same. Each query
will be exported to the same workbook on a different sheet.
If you want it as VBA code (I recommend it), save the macro AS a VB module
and it will translate the macro actions into code.
If you want a more robust process, on my website
(
www.rogersaccesslibrary.com), is a small Access database sample called
"ExportToExcel.mdb" which illustrates how to do this. You can find it here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=350. It
requires some programming knowledge, however.
--
--Roger Carlson
MS Access MVP
Access Database Samples:
www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
