ACC2000: Linked Tables Are Not Included in the List of Tables to Import into (258429)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q258429
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

When you import a text file or a Microsoft Excel workbook, the Import Text Wizard and the Import Spreadsheet Wizard enable you to add the data to an existing table. However, linked tables do not appear in the list of available tables to import into.

RESOLUTION

Import the data into a new, temporary table. Then use an append query to insert the data from the temporary table to the linked table. You can delete the temporary table after you append the data.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

In Microsoft Access 97 and 2000, the third page of the Import Text Wizard and Import Spreadsheet Wizard prompts you to choose where to store the data. You are given two choices:
  • In a New Table
  • In an Existing Table
In Access 97, if you choose In an Existing Table, a list displays all the tables in the database, including linked tables.

In Access 2000, however, the list displays only native tables. The list does not include linked tables.

Steps to Reproduce the Behavior

  1. Start Microsoft Access, and then open the sample database Northwind.mdb.
  2. Right-click the Shippers table, and then click Export.
  3. Make a note of the folder listed in the Save in box. Then, in the Save as type list, click Text Files (*.txt;*.csv;*.tab;*.asc), and then click Save. Access saves the Shippers.txt file in the folder listed in the Save in box.
  4. When the Import Text Wizard appears, click Finish, and then click OK when Access informs you that the export is finished.
  5. On the File menu, point to Get External Data, and then click Link Tables.
  6. In the Look in box in the Link dialog box, browse to the C:\Program Files\Microsoft Office\Office\Samples\Inventory.mdb sample database that is included with Access 2000, and link the Rooms table.
  7. On the File menu, point to Get External Data, and then click Import.
  8. In the Look in box in the Link dialog box, browse to the folder where Access saved the Shippers.txt file.
  9. In the Files of type list, click Text Files (*.txt;*.csv;*.tab;*.asc), and then click Import.
  10. When the Import Text Wizard appears, click Next twice, click In an Existing Table, and note that the list does not display the linked table, Rooms.

REFERENCES

For more information about append queries, click Microsoft Access Help on the Help menu, type append records from one table to another table using an append query in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:6/30/2004
Keywords:kbbug kbpending KB258429
©2004 Microsoft Corporation. All rights reserved.