Export Access Table to Excel in different sheet

G

Guest

I had a Access mdb with 2 tables and hope to export to Excel (export.xls)
which has 2 sheets for different tables (table1, table2)

I use "Docmd.outputto" command but it also allow to export one table, How
can I do it?

DoCmd.OutputTo acOutputTable, "table1", "MicrosoftExcel(*.xls)",
"export.xls", True, ""


Thanks for help!
 

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

Export Access Table and format it in Excel 2
How to use VBA to export a Table without Headers and Borders 2
Exporting table to Excel - getting error - help please. 2
export table and give it a name from the value in another unbound table 1
Export data from filtered subform to Excel ? 1
Format exported Excel cells 1
Fixed length when exporting to Excel 3
Export Access Table with Memo Field to Excel 2

Top