Linking to Another Type of Database
Even if you're not ready to actually import data from a database management system (such as FoxPro), you still might want to make changes to it by using Access. You can link to other types of databases and to Excel spreadsheets.
Link to Excel Spreadsheets
Linking to Excel spreadsheets involves the following steps:
- Open the database that will contain the link.
- With Tables selected as the object type, right-click in the Navigation Pane and select Import and then Excel from the context menu. (Alternatively, you can select Excel from the Import & Link group on the External Data tab of the Ribbon.) The Get External Data - Excel Spreadsheet dialog appears.
- Click Browse to locate the spreadsheet whose data you want to link to.
- Designate that you want to Link to the data source by creating a linked table.
- Click OK. The Link Spreadsheet Wizard appears.
- Select Show Worksheets or Show Named Ranges, as appropriate, and then click Next.
- Click to select First Row Contains Column Headings, if appropriate.
- Click Next.
- Type a name for the linked table.
- Click Finish, and then click OK. An icon associated with the linked table appears.
Link to Other Databases
In addition to linking to Access tables and Excel spreadsheets, you might want to link to dBASE, FoxPro, Paradox, and other database files. Here are the required steps:
- Open the database that will contain the links.
- With Tables selected in the object list, right-click in the Navigation Pane and select Link Tables from the context menu. (Alternatively, you can select the appropriate data type [for example, dBASE] from the More dropdown in the Import & Link group on the External Data tab of the Ribbon.)
- Click Browse and locate the file containing the data you want to link to.
- Select Link to the data source by creating a linked table.
- Click OK. The table appears in the Navigation Pane with the appropriate icon (for example, dBASE).
When working with linked tables in other databases, you need to remember a few important things, including the following:
- When you link a table to the source, there are some properties that you cannot change in the linked table. The descriptions of these properties appear in red while in Design view of the table.
- Any data you change in a linked table changes in the source table, too.
In this tutorial:
- Sharing Data with Other Applications
- What Is External Data?
- Looking at Supported File Formats
- Exporting to an Excel Spreadsheet
- Exporting to ASCII
- Importing from Another Access Database
- Importing ASCII Data
- Linking to Tables in Another Access Database
- Linking to Another Type of Database
- Linking to SQL Server Databases
- The Linked Table Manager