How to: Access Visual FoxPro Data in Microsoft Office
You can access data from Visual FoxPro databases and tables in Microsoft Office applications, such as Microsoft Excel or Microsoft Word, using the Visual FoxPro OLE DB Provider.
Note
You can import Visual FoxPro data using the Visual FoxPro OLE DB Provider only in Office XP.
To connect to a Visual FoxPro database or table in Excel
Open an Excel worksheet.
From the Data menu, point to Import External Data, and click Import Data.
In the Select Data Source dialog box, click New Source Data Connection.
In the Data Connection Wizard, select Other/Advanced.
In the Provider tab, select Microsoft OLE DB Provider for Visual FoxPro.
The Connection tab in the Data Link Properties dialog box appears.
To connect to a Visual FoxPro database or table in Word
Open a Word document.
From the View menu, point to Toolbars, and click Database.
On the Database toolbar, click the Insert Database icon.
In the Database dialog box, click Get Data.
In the Select Data Source dialog box, click New Source Data Connection.
In the Data Connection Wizard, select Other/Advanced.
In the Provider tab, select Microsoft OLE DB Provider for Visual FoxPro.
The Connection tab in the Data Link Properties dialog box appears.
To add a Visual FoxPro database or table folder
On the Connection tab and in the Select or enter a database name box, type path and name of the database or table folder you want.
-or-
To browse for a Visual FoxPro database or table folder, click the ellipsis (...) button to the right of the Select or enter a database name box to open the Configure Connection dialog box.
Specify a different collating sequence if desired.
To test the connection, click Test Connection. If connection is successful, click OK.
See Also
Tasks
How to: Access Visual FoxPro Data in Visual Studio
Reference
OLE DB Provider for Visual FoxPro
Language Reference for OLE DB Development