Import Microsoft Access Data Into Excel

Microsoft Access is a great place to store and organize data into tables, and creating queries to generate specific reports. Excel simplifies the process of presenting the data into single worksheets. Here we will show the steps to import an Access table into Excel.

Open up a new or existing Excel worksheet that you want to add the data to and click Data \ Get External Data \ From Access.

Next, browse to the Access database you want to get table information from and double click.

Now you will be able to scroll to the table within the database you want to add to Excel and double click.

The Import Data dialog box will open up for you to make various selections, in this example we are importing the table data so we can leave the default settings and select the cell to start the data import. Click Ok.

The data from the table will now be shown on the Excel worksheet in the same order as the table.

This article was originally written on 04/15/09 Tagged with: Excel, Office, Windows

Daily Email Updates

You can get our how-to articles in your inbox each day for free. Just enter your name and email below:

Comments (3)

April 15, 2009 11:05 am

Biggles

Ah, this will come in handy.

Great How-To
May 28, 2009 11:05 pm

AccessNerd

Nice tip. Access has always been weak with graphing and charting, a key strength Excel offers.
November 2, 2009 7:02 am

Jim

I'm using Access 2000 and Excel 2003. I keep getting access errors when I try to connect to the DB with Excel while someone else has Access DB open. Any suggestions - other than having the other user exit the Access DB?


Name:
Email:

Import Microsoft Access Data Into Excel

Comments (3)

If you have a computer help question, click here to leave it on the forums instead.