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


M

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
 
Ad

Advertisements

Ad

Advertisements

M

M Skabialka

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

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

Top