Menu
Simba Technologies
Simba Technologies

Simba ODBC Drivers
Quick Start Guide for Windows

Using Microsoft Access

In Microsoft Access, you can connect to your data store by using either of the following methods:

The following procedures are written for Microsoft Access 2013. Simba ODBC drivers also support Access 2010.

Important:

Make sure that the bitness of the driver that you are using matches the bitness of Access. If you are using the 32-bit version of Access, then you need to use the 32-bit version of the driver. If you are using the 64-bit version of Access, then you need to use the 64-bit version of the driver. For more information about diagnosing the issue, see Architecture Mismatch Problems.

Importing Data

To import your data:

  1. In Access, select the External Data tab in the ribbon and then click ODBC Database.
  2. Select Import the Source Data into a New Table in the Current Database and then click OK.
  3. In the Select Data Source dialog box, select the Machine Data Source tab, then select your DSN from the list, and then click OK.
  4. If you are prompted to authenticate the connection, type your credentials for accessing the data store and then click OK.
  5. In the Import Objects dialog box, select the tables that you want to import, and then click OK.
  6. In the Get External Data dialog box, select the Save Import Steps check box if you want to save the import process so that you can run it again at a later time, and then click Close.

The tables that you selected appear in the Navigation Pane on the left.

Note:

For information about known issues that you might encounter while using Simba ODBC drivers in Microsoft Access, see Known Issues When Using Microsoft Office.

Linking to Data

To link to your data:

  1. In Access, select the External Data tab in the ribbon and then click ODBC Database.
  2. Select Link to the Data Source by Creating a Linked Table and then click OK.
  3. In the Select Data Source dialog box, select the Machine Data Source tab, then select your DSN from the list, and then click OK.
  4. If you are prompted to authenticate the connection, type your credentials for accessing the data store and then click OK.
  5. In the Link Tables dialog box, select the tables that you want to link to, and then click OK.
  6. If the Select Unique Record Identifier dialog box opens, select the column that contains the unique identifiers for the rows in the table (for example, the primary key column) and then click OK. You might be prompted to do this for multiple tables.

Access creates a linked table in the Navigation Pane for each table that you selected.

Note:

For information about known issues that you might encounter while using Simba ODBC drivers in Microsoft Access, see Known Issues When Using Microsoft Office.