Results 1 to 5 of 5
  1. #1
    Xerin is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    4

    Exporting to formatted Excel file


    I need to export data from Access into an Excel spreadsheet with special formatting (several columns have drop-down lists, etc.).

    Any suggestions on the best way to do this? I know you can create a new Excel spreadsheet through an Access export, but how do you add data to an existing spreadsheet while retaining the formatting of the spreadsheet?

    I need a way to do this systematically, since there are about 100 spreadsheets that will need to be regularly updated in this way.

    Thanks for your help!

  2. #2
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224

  3. #3
    Xerin is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    4
    Thanks for the link, I'll check it out.

  4. #4
    Xerin is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    4
    I'm trying to use the TransferSpreadsheet method, but for some reason it creates a new tab in the spreadsheet instead of importing the data into the existing tab. Any suggestions on how to fix this?

  5. #5
    Xerin is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    4
    I got it to work, thanks again.

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

Similar Threads

  1. Exporting a Access Report to an Excel File
    By Coffee in forum Import/Export Data
    Replies: 2
    Last Post: 07-28-2014, 11:32 AM
  2. Replies: 7
    Last Post: 08-05-2011, 10:59 AM
  3. Formatted Excel Output
    By jerryrs in forum Import/Export Data
    Replies: 6
    Last Post: 02-26-2011, 11:58 PM
  4. Exporting query to Excel file with password?
    By jvera524 in forum Access
    Replies: 0
    Last Post: 12-06-2010, 11:24 AM
  5. Exporting to Excel Date Stamped File
    By BED in forum Import/Export Data
    Replies: 1
    Last Post: 08-07-2010, 05:53 PM

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