ACC1x: Import/Append Actions Return Errors for Each Record

Last reviewed: June 3, 1997
Article ID: Q100922
The information in this article applies to:
  • Microsoft Access version 1.1

SYMPTOMS

Executing import and append actions that cause every record to return an import error generates the following error message:

   Couldn't Import. No records found or all records contained errors.

After this error message is displayed, an empty Import Errors table is created. Also, the Help jump for this error message does not display a Help topic, but instead takes you to the Microsoft Access Help Table of Contents.

RESOLUTION

To avoid returning an import error for all records, either modify the existing table's structure or modify the file itself. If at least one record imports correctly, you will not receive the above error message and the Import Errors table will include the correct error descriptions for each error.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 1.1. This problem no longer occurs in Microsoft Access version 2.0.

MORE INFORMATION

Steps to Reproduce Problem

  1. Open the sample database NWIND.MDB.

  2. From the File menu, choose Export. Select Text [Delimited].

  3. Select the Customers table. Name the file CUSTOMER.TXT.

  4. In the Export Text Options box, choose OK.

  5. From the File menu, choose Import. Select Text [Delimited] again.

  6. Select the CUSTOMER.TXT file.

  7. Choose Append to Existing Table, select the Customers table, and choose OK.

         NOTE: Due to an indexing violation, trying to use import
         and append actions to move the CUSTOMER.TXT file back to the
         Customers table causes an error for each record.
    

    After a few seconds, the above error message is displayed. Note that the Help jump has taken you only to the Help Table of Contents. At the same time, an empty Import Errors table has been created.


Additional query words: table of contents Help table jump import append TOC
Keywords : IntpOthr IsmOthr kbusage
Version : 1.1
Platform : WINDOWS
Hardware : X86
Issue type : kbbug
Resolution Type : kbworkaround


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 3, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.