Exporting Access Query to Excel

J

James C.

I have an (many) access queries that I am currently running one by one and
copying the data into a spreadsheet in excel. That spreadsheet is then linked
to another spreadsheet which is my "Final Report" version.

I would like to automate the process so that I can I can run a module and
one at a time it will run query1....and export that data to specificed
row/column in my specified workbook and then go to the next query.

I know how to create a module to run the queries...no problem there, but how
to I tell it to export the data to my specific workbook with my specific rows
and columns?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Need Help with Macro Security 1
Integrating information from Word to Excel (not mail merge) 1
Migrating from 2010 to 2013 - having issues: Exporting to xml 0
Excel does not accept text format! 0
Linking data in MS Word into Excel 5
Adding data to MS Access from csv file 0
Automatic Report Exporting 3

Top