Import or link data and import database objects

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

What do you want to do?

Learn about importing and linking

Learn about importing and linking data and importing database objects

Get more information to help decide whether to import or link tables

Summary of data sources Microsoft Access can import or link to

Import database objects

Import or link tables from another Microsoft Access database or Microsoft Access project

Import database objects from another Microsoft Access database or Microsoft Access project

Import or link data from HTML files or Web components

Import or link (read-only) HTML tables and lists

Import or link (read-only) data on an FTP or HTTP Internet server

Import or link data from other programs or file formats

Learn about the Import Errors table

Import or link dBASE files

Import or link Paradox tables

Import or link SQL database tables or data from other ODBC data sources

Import or link data from Microsoft Outlook or Microsoft Exchange Server

Import or link data from a spreadsheet

Import or link a delimited or fixed-width text file

Learn about import/export specifications and Schema.ini files

Import a Microsoft Works database

Manage linked tables

Use the MSysConf table in a Microsoft Access database with linked SQL databases

Delete the link to a linked table in a Microsoft Access database

View, refresh, or change the file name and path for linked tables in a Microsoft Access database

Rename and set properties for linked tables in a Microsoft Access database

Obtain optimal performance with linked tables in a Microsoft Access database

Automate importing

Automate importing data using a macro or Visual Basic code