Hi,
My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.
In the Import, Export, and Link dialog boxes in Microsoft Access 2000,
FoxPro is not listed as an option for file type.
This occurs because the Microsoft FoxPro ISAM driver is no longer included
with Microsoft Access 2000.
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.
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.
For more information, please see the article below.
225861 No options are available to import, link, or export to the FoxPro
file
http://support.microsoft.com/?id=225861
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Amy Vargo
Microsoft Access Engineer
This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.
