Article ID: 225861 - View products that this article applies to.
This article was previously published under Q225861
For a Microsoft Access 2002 version of this article, see 286224
For a Microsoft Office Access 2003 version of this article, see 824264This article applies only to a Microsoft Access database (.mdb).
Moderate: Requires basic macro, coding, and interoperability skills.
In the Import, Export, and Link dialog boxes in Microsoft Access 2000, FoxPro is not listed as an option for file type.
The Microsoft FoxPro ISAM driver is no longer included with Microsoft Access.
To import from, link to, and export to Microsoft FoxPro, use the Visual FoxPro ODBC driver, as demonstrated in the following steps.
Import from FoxPro
Link to FoxPro
Export to FoxPro
Access to FoxPro data through the Microsoft Jet database engine was provided in earlier versions of Microsoft Access and earlier versions of the Microsoft Jet database engine. However, with Access 2000, access to Microsoft FoxPro data is possible only through the Microsoft Visual FoxPro ODBC driver. Access to FoxPro data through the Microsoft Jet database engine is no longer supported.
Steps to Reproduce Behavior
For more information about setting up ODBC data sources, click Microsoft Access Help on the Help menu, type setup up ODBC data sources in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
For information about converting databases that have linked FoxPro tables, please see the following article in the Microsoft Knowledge Base:
200393For additional information about issues you may encounter when importing, linking, and exporting FoxPro data, please click the article numbers below to view the articles in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/200393/EN-US/ )ACC2000: Linked FoxPro Icon Appears Dimmed in Converted Database
(https://support.microsoft.com/kb/237819/EN-US/ )ACC2000: "ODBC Call Failed" Error Message Exporting to FoxPro
(https://support.microsoft.com/kb/188401/EN-US/ )PRB: ACCESS Cannot Import/Link Table if Index Contains Function
Article ID: 225861 - Last Review: August 10, 2004 - Revision: 2.0