Results 1 to 3 of 3
  1. #1
    ItsJustMe64 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    May 2019
    Posts
    1

    Can you Export Query as a New Tab on existing Excel file

    I have four queries that need to be placed in the same Excel file. 3 of the queries need to be totaled. When I export individually they carry over the totals from the query, but when I use the button that triggers the [DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml,] the Totals do not flow to the file.



    I need to either export the queries one at a time into the same file or find code to include the totals on the Transfer.

    Can someone help

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    How are you 'totaling' the queries - the Totals button on ribbon that opens totals row? These totals transfer with manual export?

    If you want detail records as well as summary calcs, should be able to export a simple report with the aggregate calcs intact.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Don't know what your VBA expertise/ability is, but there are lots of VBA examples of exporting data from Access to Excel at Ken Snell's site.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 07-14-2018, 07:22 AM
  2. export data to existing excel file
    By joshynaresh in forum Import/Export Data
    Replies: 7
    Last Post: 01-27-2014, 10:57 PM
  3. Replies: 1
    Last Post: 08-12-2013, 09:27 AM
  4. how export and replace existing file
    By sk88 in forum Access
    Replies: 6
    Last Post: 10-01-2012, 12:55 PM
  5. Export a simple query result to an excel file
    By wop_nuno in forum Import/Export Data
    Replies: 1
    Last Post: 05-21-2009, 04:18 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums