Radenkovich’s P(a)lace

or on any other data source. Ms Access ability to process large amount of data may come very handy in many cases. Of course, you can perform those analyzes in Excel itself but doing it using Access is both much more comfortable and error-proof. Excel is irreplaceable when you should check less than hundred rows of data but when row numbers came to several hundreds and more possibility to make errors raise exponentially. At the other hand, Access operate with whole columns and it make this job easily as possible. On this post it will be explained how to link Excel on Access, but you can use the vary same method to link Excel on any other data source like text files, xBase, ODBC…

There are two ways to import data from Access to Excel, one is Copy/Paste and second one is by using Import data menu option.

Here come step-by-step instructions:

1. on menu Data/Import External Data/Import Data…
2. on the next dialog Select Data Source, change Files of type (if necessary) and select your Access mdb file
3. on new dialog you can choose any tables or queries from your Access MDB file. Select one and click OK button
4. on Import Data dialog, chose between inserting in Existing worksheet or in a new worksheet and click OK button
5. after few seconds, depending on query speed or quantity of returning data you will get Access query/table in your Excel sheet
6. now, each time you need to refresh those data all you have to do is right-click on rows with Access data in Excel sheet and choose Refresh…