How can I push Access Data into Excel from Access 2007?

[M Skabialka]

I have written macros in Access and Excel to extract data from multiple
spreadsheets, manipulate the data, then import it into tables in Access 2007
to run reports, etc. The data is replaced on a monthly basis. This part
works fine.

Now I would like to take this data from Access, run queries and push the
data back into an Excel template with 101 worksheets, the first sheet being
a summary, the rest numbered from 001 to 100.
I would like to control this from Access, even if it means running Excel VBA
code from Access (which I do for the importing).

I tried one example that included this:
Workbooks.OpenDatabase strPathFile, strSQL, xlCmdTable
but it opened a database connection window then said I couldn't do it
because the database was already open. Importing from Excel doesn't open
this window.

Are there examples of this out there that I can adapt?

Thanks,
Mich

 

[Douglas J. Steele]

Check what Ken Snell has at
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm

 

[M Skabialka]

There's enough options on this page that I'm sure one of them will work
perfectly - thanks.
Mich