Output to macro action

C

caats557

In Access 2003 when you used the transfer spreadsheet action on a table, and
transferred to Excel, the table would appear as a worksheet. If you
transferred another table, using the same excel workbook file name, the
second table would appear as a worksheet in the same excel workbook.

When I used output to in Access 2007, the table outputs to an excel
workbook. I have not been able to determine how to have multiple tables
output to the same workbook as different worksheets.

Any ideas
 
S

Steve Schapel

Caats,

I am not sure about this specifically, without testing. But you are talking
about 2 different macro actions here: TransferSpreadsheet and OutputTo. Can
you please check your requirements with both actions?
 

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

Output to specific Excel worksheet 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Output to : Template file 3
How to count table records in a macro 1
Output to Excel 1
Access macro: How to output 3 queries to 3 tabs in 1 Excel workboo 8
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Exporting Table to Specific Excel Worksheet 2

Top