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
Open any Access database.
On the File menu, point to Get External Data, and then click Import.
In the Import dialog box, click the Files of type list.
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:
ACC2000: Linked FoxPro Icon Appears Dimmed in Converted Database
For 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: