Microsoft KB Archive/258429

= ACC2000: Linked Tables Are Not Included in the List of Tables to Import into =

Article ID: 258429

Article Last Modified on 6/30/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.

