Importing data from Access

Summary

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.

access location

2. Now select the data source where your access file is located

select data source

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.

showing table and query

importing location

4.  Hit OK button and your data is ready to fry.

result

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment