Microsoft Office Tutorials and References
In Depth Information
Importing Data from Microsoft Access
Importing Data from Microsoft Access
Microsoft Access is used in many organizations to manage a series of tables that interact with each
other, such as a Customers table, an Orders table, and an Invoices table. Managing data in Access
provides the benefit of a relational database where you can ensure data integrity, prevent
redundancy, and easily generate datasets via queries.
Excel 2013 offers several methods for getting your Access data into your Excel data model.
The drag-and-drop method
For simplicity, you just can’t beat the drag-and-drop method. You can simultaneously open an empty
Excel workbook and an Access database from which you want to import a table or query. When both
are open, resize each application’s window so that they’re both fully visible on your screen.
Hover the mouse over the Access table or query you want to copy into Excel. Now click the table and
drag it to the blank worksheet in Excel (see Figure 18-1).
Figure 18-1: Copy an Access table using the drag-and-drop method.
The drag-and-drop method comes in handy when you’re doing a quick one-time analysis where you
need a specific set of data in Excel. However, the method isn’t so useful for the following:
➤ You expect this step to occur routinely, as a part of a repeated analysis or report.
➤ You expect the users of your Excel presentation to get or update the data via this method.
➤ It’s not possible or convenient for you to simply open up Access every time you need the
In the preceding scenarios, it’s much better to use another technique.
Search JabSto ::

Custom Search