Export Query to Excel

  • Thread starter Thread starter AJOLSON
  • Start date Start date
A

AJOLSON

I am exporting a query to excel using the following code:
DoCmd.OutputTo acOutputQuery, "AllOut", acFormatXLS, , True

It creates a new excel file called AllOut and places the information in a
worksheet that it names AllOut. Where that works I would like to take this
to the next level and just cant.

What I would like to do is when the query is exported I want the query
exported to a excel file that has already been created. Specifically I would
like the query to open up that pre-determined file and place the results of
the query in a specified worksheet within the excel file. And if at all
possible I would like it to place it in a pre-determined row or cell within
that worksheet, although the last is not that critical.

Any help would be appreciated

Thanks
Andy
 
You would have to use Office Automation for that. But here's an
alternative. Use the TransferSpreadsheet method to send your query to an
existing excel file in a new tab and then (in Excel) link the values from
the new tab into the cells you want. It's kind of a semi-automation method.

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.

--
--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
 
Back
Top