Article ID: 321003
Article Last Modified on 3/27/2007
APPLIES TO
- Microsoft Office Access 2007
- Microsoft Office Access 2003
- Microsoft Access 2002 Standard Edition
This article was previously published under Q321003
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.accdb and.mdb).
SYMPTOMS
When you try to import dBASE files into Access, you may receive the following error message:
CAUSE
This behavior may occur if the Borland folder exists on your computer and either of the following conditions is true:
- The Borland Database Engine (BDE) was previously installed on your computer but was later removed, leaving an empty folder.
-or-
- The BDE was installed incorrectly.
RESOLUTION
To resolve this issue, you can either reinstall BDE or use the following steps to remove it:
- Start Windows Explorer, and then browse to the Borland folder.
If you cannot locate the folder, follow these steps.NOTE: Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
- Click Start, and then click Search.
- Click All files and folders.
- In the All or part of the file name box, type Borland.
- In the Look in list, click My Computer.
- Click Search.
- Rename the Borland folder as BorlandOld. (For example, rename C:\Borland as C:\BorlandOld.)
- Import the dBASE files again.
MORE INFORMATION
If you remove or rename the Borland folder, Access uses its own indexed sequential access method (ISAM) driver to import dBASE data.
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.
REFERENCES
For additional information about how to use dBASE data with Access, click the article numbers below to view the articles in the Microsoft Knowledge Base:
307455 ACC2002: How to Control Whether Access Loads the Borland Data Engine (BDE)
230125 How to use dBASE data with Access 2000 and Jet
283294 ACC2002: Supported Data Sources for Importing, Exporting, and Linking in an Access 2002 Database
For more information about how to link a dBASE file to an Access database or how to import a dBASE file into an Access project, click Microsoft Access Help on the Help menu, type import a dBASE file in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Additional query words: prb ACC2002 reviewdocid ACC2007
Keywords: kbimport kberrmsg kbprb KB321003
