Microsoft Office Tutorials and References
In Depth Information
Importing Data from Microsoft Access
Figure 18-7: Your imported Access data.
The incredibly powerful thing about importing data this way is that it’s refreshable. That’s right. If
you import data from Access using this technique, Excel creates a table that you can update by
right-clicking it and selecting Refresh from the pop-up menu, as shown in Figure 18-8. When you
update your imported data, Excel reconnects to your Access database and imports the data again.
As long as a connection to your database is available, you can refresh with a mere click of the
Figure 18-8: As long as a connection to your database is available, you can update your table with the latest
Again, a major advantage to using the Get External Data group is that you can establish a refreshable
data connection between Excel and Access. In most cases, you can set up the connection one time
and then just update the data connection when needed. You can even record an Excel macro to
update the data on some trigger or event, which is ideal for automating the transfer of data from