Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Stuck at work..., Missouri, USA
    Thanked 0 Times in 0 Posts

    Export to Excel with Multiple Tabs (2003)

    I have code that will export a table or query to Excel and can split it into multiple FILES based on a field in the data.

    What I need to do now is export to Excel and split into multiple TABS based on a field.

    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Export to Excel with Multiple Tabs (2003)

    When you export to an existing workbook, Access will export to a sheet with the same name as the table or query being exported. If this sheet doesn't exist, it will be created, and if it already exists, it will be overwritten.
    So one option is change the name of the table/query each time, so that the data will be written to different sheets.

    Another option is not to export from Access, but to import into Excel, using the CopyFromRecordset method - look it up in the Excel VBA help, there's a complete example.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts