Importing data from Access
Many people (especially in Finance, Marketing or Data Analyst) use Excel and Access almost interchangeably, feeding data between both applications. But if you’ve never done it, then how do you? There are several ways to import data from Access to Excel, and you don’t even need to have Access open. You can import Tables, as well as most queries (Crosstab queries aren’t supported), so it’s up to you to determine which you want to import. In general, since you use Access to store large amounts of data in tables, then use its fantastic querying ability to pare that data down into manageable chunks, you’ll find yourself importing query results most of the time.
In this article we’ll discuss the easiest way to import Access data into Excel whether from Tables or Queries. To get started go to Excel’s Data menu Get External Data From Access.
From there, select the database that you want to use as your import source. Excel will then display a list of the available Tables and Queries that can be imported. From there, select the database that you want to use as your import source. Excel will then display a list of the available Tables and Queries that can be imported.
Properties – While you can certainly get detailed with Import Properties, for this article I just wanted to point out a feature that’s handy if you have a data set that refreshes at regular intervals: you can tell Excel to automatically refresh your Access data whenever you want.
How to import data from access
Now I will show you how to import data from access. For an example I use my Sales database again. Lets start ..
1. First select the cell in excel where you want to import your data or you can select import location in the last step. Then select From access from Data Tab under Get External Data group.
2. Now select the data source where your access file is located
3. After opening the file, you find tables and queries in your access file. In my access file I have only one database named Sales Databse and two queries named Date Wise Value and Product Wise Value. Select the required one. I select my database for example. Click OK. A new window is popup and indicating where to import your data.
4. Hit OK button and your data is ready to fry.