Importing visual foxpro data into microsoft access

Found It. Microsoft dropped the ODBC driver but this one worked for me. Seems like there is a way to use odbc. Once you do the above, then you can use the standard import options from access to pull the data in, and in fact you can actually link to the table and edit the data from access without having to import. Also the above driver supports the so called free tables.

Just pick the visual Foxpro database driver. As a side note, then above link is a little bit confusing, you want to scroll down a little bit and choose the MSI file…not the first download choice. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 11 years, 10 months ago. Active 9 years, 1 month ago. Viewed 6k times. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services. Privacy policy. You can import Visual FoxPro data into your Microsoft Excel worksheet if you have defined a data source for it.

If the database accessed by your data source includes tables, select a table from the Add Tables dialog box. Microsoft Query displays the added table in the top half of the query designer. In Microsoft Office Access and in Microsoft Office Access , you may not be able to import, export, or link to Microsoft FoxPro databases directly because the Import , Export , and Link dialog boxes do not include the FoxPro database as an option in the Files of type list.

To do so, follow these steps:. If you use Access , click to select the Import the source data into a new table in the current database option in the Select the source and destination of the data dialog box, and then click OK.

In the Import Objects dialog box, click the tables that you want to link, and then click OK. If you use Access , click to select the Link to the data source by creating a linked table option in the Select the source and destination of the data dialog box, and then click OK.

In the Link Tables dialog box, click the tables that you want to import, and then click OK. In the Export Table 'tablename' To In the Export dialog box, type the name of the new table, and then click OK. In earlier versions of Access and the Microsoft Jet database engine, you can move data between FoxPro databases and Access databases.