ACC2000: Linked Tables Are Not Included in the List of Tables to Import into (258429)
The information in this article applies to:
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.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. REFERENCESFor 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: | Major | Last Reviewed: | 6/30/2004 |
---|
Keywords: | kbbug kbpending KB258429 |
---|
|