Does anyone know of a way to import these files into Access? Any help would be very much appreciated. dbc then begins the data stream on one line. If I open the file with excel or as text it begins with. In the Import Objects dialog box, click the tables that you want to import, and then click OK. In the Select Data Source dialog box, click the Visual FoxPro data source that you created in step 3, and then click OK.Ĩ. In the Import dialog box, click ODBC Databases in the Files of type list.ħ.
On the File menu, point to Get External Data, and then click Import.Ħ. Start Access, and then open your Access database.ĥ. In the Administrative Tools window, double-click Data Sources (ODBC), and then add a new ODBC data source for your FoxPro database or tables by selecting the appropriate Visual FoxPro driver.Ĥ. In Control Panel, double-click Administrative Tools.ģ. To do so, follow these steps:ġ.Ĝlick Start, and then click Control Panel.Ģ. “To import data from a FoxPro database, use the Microsoft Visual FoxPro ODBC driver. I’ve tried the following but it did not work: When I import the data straight to Access it errors with:Įxternal table is not in the expected format.
dbf files from a very old version of Visual FoxPro (version 2.1) into Access (2003).
