Output to macro action

Discussion in 'Access Macros' started by caats557, May 14, 2010.

  1. caats557

    caats557 Guest

    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
     
    caats557, May 14, 2010
    #1
    1. Advertisements

  2. 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?
     
    Steve Schapel, May 14, 2010
    #2
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.