How to access Visual FoxPro data in Microsoft Office?

Sometimes users who are using Microsoft Visual FoxPro, need to import their databases and tables in Microsoft Office applications, such as: Microsoft Excel or Microsoft Word. But don’t know how? Most of the time users take help of a third-party converter tool that can perform conversion of DBF files into Word document format or Excel worksheet format. As they are not aware of an easy manual trick, they have to use a third-party converter tool.

But the manual trick doesn’t require any third-party tool or any other application to perform the operation. By using Microsoft Visual FoxPro Microsoft Visual FoxPro OLE DB Provider, the manual trick can be executed with ease.

First of all, you need to connect your Visual FoxPro database in Microsoft Excel or Word. Learn how to do that?

In Microsoft Excel, follow the steps given below:

1. Launch Microsoft Excel on your system.
2. From the Data menu, point to Import External Data, and click Import Data.
3. In the Select Data Source dialog box, click New Source Data Connection.
4. In the Data Connection Wizard, select Other/Advanced.
5. In the Provider tab, select Microsoft OLE DB Provider for Visual FoxPro.

The Connection tab in the Data Link Properties dialog box appears.

In Microsoft Word, follow the steps given below:

1. Launch Microsoft Word on your system.
2. From the View menu, point to Toolbars, and click Database.
3. On the Database toolbar, click the Insert Database icon.
4. In the Database dialog box, click Get Data.
5. In the Select Data Source dialog box, click New Source Data Connection.
6. In the Data Connection Wizard, select Other/Advanced.
7. 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, follow the steps given below:

1. 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
2. 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.
3. Specify a different collating sequence if desired.
4. To test the connection, click Test Connection. If connection is successful, click OK.