ACC: "External Table Isn't in Expected Format" Error Message

Last reviewed: May 7, 1997
Article ID: Q135374
The information in this article applies to:
  • Microsoft Access versions 7.0, 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

When you try to import a delimited text file, you may receive the following error message:

   External table isn't in expected format.

No data is imported, nor is an Import Errors table created.

CAUSE

The first record in the delimited text file contains data in a format that Microsoft Access cannot recognize. For example, the record contains an incorrect field separator or is missing a field delimiter.

Microsoft Access must be able to import the first record of data correctly before continuing to import the rest of the file. If the first record has any data format problems, Microsoft Access stops the import process. However, if the second or a subsequent record has unrecognizable data, Microsoft Access continues importing and creates an Import Errors table that includes error descriptions of the data problem.

RESOLUTION

Open the file in any text editor, such as WordPad, and change the data to a properly delimited format.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Start WordPad and type the following values into a new document:

          "Davolio"~"Nancy"
          "King","Robert"
          "Suyama","Michael"
    

  2. Save the file as a text document named Test.txt, and then close WordPad.

  3. Start Microsoft Access and create a new database called Db1.mdb.

  4. Create the following new macro:

          Macro Name     Action
          -------------------------------------
          Macro1         TransferText
    
          Macro1 Actions
          -------------------------------------
          TransferText
             Transfer Type: Import Delimited
             Table Name: Test1
             File Name: <full path to Test.txt>
             Has Field Names: No
    
    

  5. Close and save the Macro1 macro.

  6. From the Database window, run the Macro1 macro. Note that you receive the following error message:

          External table isn't in expected format
    

REFERENCES

For more information about importing delimited text files, search the Help Index for "importing data," or ask the Microsoft Access 97 Office Assistant.


Keywords : IsmTxtd kb3rdparty kberrmsg
Version : 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided


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: May 7, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.