Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2010
    Thanked 0 Times in 0 Posts

    Exporting MS Access to Ms Excel with Excel format

    I’ve read a lot of different article on the internet about being able to export a table from MS Access to Ms Excel.

    Problem I’m having is that I don’t know which one would work best for me, so I thought since I’ve gotten such great advice from this form I will ask.

    I have a query that updates a table in access.
    What I would like to have happen in the export from access to excel

    Currently I have a number of queries that updates number of table daily.
    Then I manual export the tables to a excel files
    Then I spend 15 -20 minutes formatting the excel fine. “I format all the table to excel files that same way.
    Once this is done I email it out in excel format to different managers that need to make commits and then email the spread sheet back to me then I import the spread sheets and record there comments.

    If at all possible I would like all the files to import into one spread sheet just into different tabs. I have a bout 4 different group.

    Below are some of the articles I’ve read about exporting from access to excel.

    Looking for any advice example ect

    Thanks for all your help and advice
    Last edited by WendellB; 2011-02-15 at 15:34. Reason: Make links live

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 65 Times in 64 Posts
    As you have discovered, there are a number of ways to move data from Access to Excel. However, if you want the data formatted in a certain way, life gets more complicated. We routinely create nearly 1000 workbooks each with 10 worksheets using an Excel template as a place to start. That gives us the basic formatting, and then all we have to do is put the data there, but we do use automation. It isn't nearly as fast as the TransferSpreadsheet method, but it gives us the ability to do things that aren't nicely structured.

    Of the articles you noted (I've changed them to hyperlinks), the two that have the most meat in my view are the Database Journal article (Danny Lesandrini is an acquaintance of mine and knows his stuff) and the Tek-Tips article - especially the last few posts in the latter. One piece of information that would be useful to add to your post is the version of Microsoft Office that you are using. There are some subtle differences in the export process and the automation code between the various versions.

Posting Permissions

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