Follow the steps below to add tables from a Microsoft Access database
- Navigate to Add Data and select Microsoft Access. Then, select the required database file.
- In the database details window, select the tables you wish to add and click ADD to finish.
|
When the 'Automatically create relationships from database' option is enabled, table relations will be automatically created based on the Primary/Foreign key relationships defined in the database.
|
Supported Versions and Prerequisites
Both Access 2003 (*.mdb) and Access 2007 (*.accdb) files are supported.
Requires Microsoft Data Connectivity Components for Office 2007. These components are installed automatically when installing Office 2007. If you are using an earlier version of office, you may get a message similar to the following:
"Microsoft.ACE.OELDB.12.0' is not registered on the local machine"
In this case, you can download these components from the following link:
http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en