Microsoft Knowledge Base Email Alertz

When you try to import dBASE files into Access, you may receive the following error message:

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

Article ID: 321003 - Last Review: March 27, 2007 - Revision: 5.1

"Unexpected Error from External Database Driver (8961)" error message when you try to import dBASE files into Access

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:
Unexpected error from external database driver (8961)

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:
  1. 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.
    1. Click Start, and then click Search.
    2. Click All files and folders.
    3. In the All or part of the file name box, type Borland.
    4. In the Look in list, click My Computer.
    5. Click Search.
  2. Rename the Borland folder as BorlandOld. (For example, rename C:\Borland as C:\BorlandOld.)
  3. 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  (http://kbalertz.com/Feedback.aspx?kbNumber=307455/EN-US/ ) ACC2002: How to Control Whether Access Loads the Borland Data Engine (BDE)
230125  (http://kbalertz.com/Feedback.aspx?kbNumber=230125/ ) How to use dBASE data with Access 2000 and Jet
283294  (http://kbalertz.com/Feedback.aspx?kbNumber=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.

APPLIES TO
  • Microsoft Office Access 2007
  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
Keywords: 
kbimport kberrmsg kbprb KB321003
       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate