Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2009
    Posts
    47

    Unanswered: How to export Access Table and save as Excel file

    I have just completed a huge ass database. And the output quer is a mkae table query Which save the output as a Table named "Final_Result". I wanted to know if there is any way to have Access save that Table as an excel table or workbook to a fixed location. i have a lot of queries so a macro runs all of them in a sequence, could the same macro do this task as well.

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Have a look at Pootle's post in the Code Bank. Not sure how to do it with Macros though as I hate using macros, always try to avoid them actually.
    Me.Geek = True

  3. #3
    Join Date
    Dec 2004
    Posts
    41
    You can do it with a macro. In the Action field select "Output To" and set-up the arguments at bottom. For Output File, you can input something like C:\Temp\ExcelFile.xls or you leave it blank and it will bring up a Save As box for the user, which is more user-friendly since you don't know whether everyone has a C:\Temp folder they can write to.

  4. #4
    Join Date
    May 2005
    Posts
    1,191
    The TransferSpreadsheet Method is an option, but I prefer taking an approach similar to Pootle's post as it allows much more flexibility and control over how the data is exported as compared to docmd.TransferSpreadsheet.
    Me.Geek = True

  5. #5
    Join Date
    Feb 2009
    Posts
    47

    Code no help

    Quote Originally Posted by nckdryr
    Have a look at Pootle's post in the Code Bank. Not sure how to do it with Macros though as I hate using macros, always try to avoid them actually.
    I downloaded the code and it just shows a

    Couple of options that are blank, no code, no macros, no moduled i dont know if it is password protected or what I looked at it in Design view but nothing.

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I usually use TransferText and create CSV files when I want to export to Excel or any other program.

    How many records does the final result table have? Can Excel cope with it?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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