Tech Xpress

Export Access Tables to Excel

Image a situation where you want to share data stored in Microsoft Access tables with your colleague.
The only problem! Your colleague is not familiar with Microsoft Access but prefers Microsoft Excel instead.

No big deal. Data stored in Microsoft Access tables can be exported to Excel sheets in a few easy steps.

1. Double click the required Microsoft Access database.

2. By default, a database window appears which displays all the tables in the database.
( If you are not in Table view, click the Tables option from the menu present on the left of the database window)

3. Right-click the Table you want to transfer and click Export.

4. Now type the name for the file and set the destination file type in the save as file box as Excel. ( Other types are also supported )

5. Click Ok and the export is complete.

Related Reading:
How to transfer your Excel spreadsheet to an Access table


Labels: , , ,

posted by Vijeesh Ravindran, Friday, November 10, 2006


I just created a small Access tool last month to set up this kind of automation. It has options to find last blank row, inserts worksheets with row limit is reached, runs Excel macros, adds headers. I would like any feedback from your readers sent to if you have tried this tool. Bob
Comment by Anonymous Anonymous on October 4, 2008 at 6:31 AM  
You can download an Access DB into Excel see this thread for more details
Wow thanks for this post! It is really helpful.. best regards, nikolai
Comment by Anonymous Jack on October 10, 2008 at 8:31 PM  
What happens if I select the table and Ctrl+C (copy)it and paste it (Ctrl+V) in Excel ?

I tried doing the Export of Access table, but then my Excel popped up an error and closed . When I checked my disc a copy of the database had been created and that too of a smaller size . Could you say why this happened ?