Using Microsoft Access
In Microsoft Access, you can connect to Spark data by using either of the following methods:
- To import the data, see Importing Data.
- To create a table that links to the data, see Linking to Data.
The following procedures are written for Microsoft Access 2013. The Simba Spark ODBC Driver also supports 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" in Troubleshooting.
Importing Data
To import Spark data:
- In Access, select the External Data tab in the ribbon and then click ODBC Database.
- Select Import the Source Data into a New Table in the Current Database and then click OK.
- In the Select Data Source dialog box, select the Machine Data Source tab, then select your DSN from the list, and then click OK.
- In the Import Objects dialog box, select the tables that you want to import, and then click OK.
- 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.
Linking to Data
To link to Spark data:
- In Access, select the External Data tab in the ribbon and then click ODBC Database.
- Select Link to the Data Source by Creating a Linked Table and then click OK.
- In the Select Data Source dialog box, select the Machine Data Source tab, then select your DSN from the list, and then click OK.
- In the Link Tables dialog box, select the tables that you want to link to, and then click OK.
- 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 Spark table that you selected.