You are linking multiple tables, you will be prompted to select unique record identifiers for each of the selected tables. To avoid inconsistencies, it is recommended to select the primary key in the SQLite table as the unique record identifier.
![ms access link table ms access link table](http://www.accessrepairnrecovery.com/blog/wp-content/uploads/2018/08/maxresdefault-1.jpg)
In the Link Tables dialog box, select the table or tables that you want to link to, and click OK.In the Get External Data - ODBC Database dialog box, select Link to the data source by creating a linked table.Linking to SQLite Data in Microsoft Access Through an ODBC Connection Double-click on the needed table to display its contents.The imported tables should appear in the Tables navigation pane on the left.
![ms access link table ms access link table](https://i.ytimg.com/vi/BY-EmHRrbwM/maxresdefault.jpg)
If you want to save the import steps to quickly repeat the process without using the wizard at a later time, select the Save import steps checkbox.
#MS ACCESS LINK TABLE HOW TO#
The following steps describe how to use Microsoft Access 2019 to import or link to your data in SQLite.
#MS ACCESS LINK TABLE DRIVERS#
For the purpose of this article, we tested an ODBC connection to SQLite through our ODBC drivers in Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010, Microsoft Access 2013, Microsoft Access 2016, Microsoft Access 2019. It is assumed that you have already installed and configured a DSN for ODBC driver for SQLite. Devart ODBC drivers support all modern versions of Access. In Microsoft Access, you can connect to your SQLite data either by importing it or creating a table that links to the data. Access can be used as a substitution for spreadsheet applications like Excel to organize, store, and retrieve large amounts of related data that can be difficult to manage in spreadsheets. Microsoft Access is a dababase management system that combines the relational database engine with a graphical user interface. This article explains how to connect Microsoft Access to SQLite through the standard ODBC interface.
![ms access link table ms access link table](http://www.accessrepairnrecovery.com/blog/wp-content/uploads/2017/05/Excel-AccessLink7.png)
Connecting Microsoft Access to SQLite Using an ODBC Driver