No options are available to import, link, or export to the FoxPro file type in Access 2000

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
(http://support.microsoft.com/kb/286224/ )
.
For a Microsoft Office Access 2003 version of this article, see 824264
(http://support.microsoft.com/kb/824264/ )
.
This article applies only to a Microsoft Access database (.mdb).

Moderate: Requires basic macro, coding, and interoperability skills.

Expand all | Collapse all

On This Page

SYMPTOMS

In the Import, Export, and Link dialog boxes in Microsoft Access 2000, FoxPro is not listed as an option for file type.
Back to the top | Give Feedback

CAUSE

The Microsoft FoxPro ISAM driver is no longer included with Microsoft Access.
Back to the top | Give Feedback

RESOLUTION

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

  1. Click Start, point to Settings, and then click Control Panel.
  2. In Control Panel, open the ODBC Data Sources (32-bit) tool, and add a new ODBC Data Source for your FoxPro database or tables by selecting the appropriate Microsoft Visual FoxPro driver.
  3. Open the Access database that you want to import into.
  4. On the File menu, point to Get External Data, and then click Import.
  5. In the Import dialog box, click ODBC Databases in the Files of type list.
  6. In the Select Data Source dialog box, select the Visual FoxPro data source that you created in step 2, and then click OK.
  7. In the Import Objects dialog box, select the tables that you want to import, and then click OK.

Link to FoxPro

  1. Click Start, point to Settings, and then click Control Panel.
  2. In Control Panel, open the ODBC Data Sources (32-bit) tool and add a new ODBC Data Source for your FoxPro database or tables by selecting the appropriate Microsoft Visual FoxPro driver.
  3. Open the Access database that you want to create the link in.
  4. On the File menu, point to Get External Data, and then click Link Tables.
  5. In the Link dialog box, click ODBC Databases in the Files of type list.
  6. In the Select Data Source dialog box, select the Visual FoxPro data source that you created in step 2, and then click OK.
  7. In the Link Tables dialog box, select the tables that you want to import, and then click OK.

Export to FoxPro

  1. Click Start, point to Settings, and then click Control Panel.
  2. In Control Panel, open the ODBC Data Sources (32-bit) tool and add a new ODBC Data Source for your FoxPro database or tables by selecting the appropriate Microsoft Visual FoxPro driver.
  3. Open the Access database that you want to export from.
  4. On the File menu, click Export.
  5. In the Export Table 'tablename' To dialog box, click ODBC Databases in the Files of type list.
  6. In the Export dialog box, type the name of the new table, and then click OK.
  7. In the Select Data Source dialog box, select the Visual FoxPro data source that you created in step 2, and then click OK.
Back to the top | Give Feedback

MORE INFORMATION

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

  1. Open any Access database.
  2. On the File menu, point to Get External Data, and then click Import.
  3. In the Import dialog box, click the Files of type list.
Note that FoxPro is not there.
Back to the top | Give Feedback

REFERENCES

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:
200393
(http://support.microsoft.com/kb/200393/EN-US/ )
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:
237819
(http://support.microsoft.com/kb/237819/EN-US/ )
ACC2000: "ODBC Call Failed" Error Message Exporting to FoxPro
188401
(http://support.microsoft.com/kb/188401/EN-US/ )
PRB: ACCESS Cannot Import/Link Table if Index Contains Function
Back to the top | Give Feedback

Properties

Article ID: 225861 - Last Review: August 10, 2004 - Revision: 2.0
APPLIES TO
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbexport kbimport kbprb KB225861
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top