Output to macro action

[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

 

[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?