ACC: Error When Importing dBASE, FoxPro, or Paradox Table

In Microsoft Access 97, when you import a Paradox file that does not contain a file extension as part of its name or does not follow the MS-DOS 8.3 file name format (that is, an 8-character name followed by a 3-character extension), you may receive the following error message: Note This error may also occur with a dBASE file in Microsoft Access 97, if the file name does not follow the MS-DOS 8.3 file name format.

In Microsoft Access 2.0 and 7.0, when you import a Paradox file that does not contain a file extension as part of its name, you may receive the following error message:

In Microsoft Access 1.x, when you import a dBASE, FoxPro, or Paradox file that does not contain a file extension as part of its name, you may receive the following error message:

Rename the file so the file has the correct extension, such as .dbf for a dBase file.

Note Although incorrect extensions may have been permitted in the past, as of February 2003, current versions of Jet require that the correct file extension is used for security reasons.

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

Microsoft has confirmed this to be a problem in Microsoft Access 1.x, 2.0, 7.0, and 97.

Steps to Reproduce Problem

The following steps use a Paradox file as an example. You can also use a dBASE or FoxPro file to reproduce the error message in Microsoft Access 1.x.

1. Rename a Paradox file so that it has no extension. For example, rename Customer.db to Customer.
2. Open a Microsoft Access database.
3. Import the file:
   
   In Microsoft Access 7.0 and 97:
   
   
   1. On the File menu, point to Get External Data, and then click Import.
   2. In the Import dialog box, click Paradox (*.db) in the Files of Type box.
   3. Type *.* in the File Name box.
   4. click the Paradox file that you created in step 1.
   5. Click Import.
   In Microsoft Access 1.x and 2.0:
   1. On the File menu, click Import.
   2. In the Import dialog box, click the appropriate version of Paradox, and then click OK.
   3. In the List Files Of Type box, click All Files (*.*).
   4. Click the file that you created in step 1.
   5. Click Import.

The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.