Import Access Data Into Excel
- 3
- Add a Comment
If you are new to Access or Excel, you may not know that you can import data from an Access database into Excel. The steps below describe a quick and easy way to accomplish this.
- Open the appropriate Excel workbook.
- From the Data menu, point to Import External Data, and then click the Import Data option.
- From the Select Data Source dialog box, click the New Source button.
- From the Data Connection Wizard dialog box, click ODBC DSN, and click Next.
- Click MS Access Database, and click Next.
- From the Select Database dialog box, locate the database file you want to import, and click OK.
- Click the name of the table containing the data you want to import, and click Next.
- Type a name and description, and click Finish.
- In the Select Data Source dialog box, click the data source you just created and click Open.
- In the Import Data dialog box, specify where you want to put the data, and then click OK.

3 Comments
Import Access Data Into Excel ~ Windows Fanatics
October 8th, 2006
at 4:09am
[…] Import Access Data Into Excel […]
Chris
January 4th, 2008
at 4:29am
After following your directions, I obtained the following error message:
[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on ‘PPG’
PPG was the name I had assigned to it
Mayur
March 12th, 2008
at 2:20pm
I am trying to import data from Access into and have been able to import one table already. However, for the second table that I’m trying to import, I get only the header row, no other records. If I try to construct a pivot table, I get more information, but a pivot table won’t do in this case.
Please advise.