1. Home
  2. MS Office
  3. Import ms access database to excel 2010 using ms query

Import MS Access Database To Excel 2010 Using MS Query

Microsoft Query is one of the most popular techniques to import data from external data sources into your Excel sheet. It offers a very flexible way of  importing data such that if the data changes in the source database then you can also get the latest updates in your excel sheet by just refreshing your spreadsheet.

MS Query can import data from the following sources.

  • Microsoft SQL Server Analysis Services
  • Microsoft Office Access
  • dBASE
  • Microsoft FoxPro
  • Microsoft Office Excel
  • Oracle
  • Paradox
  • Text file databases

Lets see how we can connect your Excel spreadsheet to an MS Access Data Source by using the Microsoft Query feature.

First of all make sure that your Access Database is up and running, and then head over to the Data tab of the Excel spreadsheet and choose the From Microsoft Query option under the Get External Sources category

Microsoft Query

Now choose your data source, i.e. MS Access in our case.

Data Source

Here browse and select the database that you wish to import into your Excel sheet.

Select DataBase

The tables of the particular database will be displayed, now move the required fields from the Available tables and columns section, to the Columns in your query section by using the ‘>’ button.

Query Wizard Column

Click Next and proceed to the Next step, and then specify any additional options like sorting etc.

Query Wizard Sort Oder

That’s it, now choose how you would like to display the data of the Microsoft Access Database in your Excel sheet, as a Table, PivotTable Report, or PivotChart and PivotTable Report.

Excel Sheet MS Query

Click OK and you will find the data imported to your Excel sheet.

MS Query Excel 2010

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.