Sometimes users, who are using MS Visual FoxPro, need to import their Visual FoxPro database and tables in Microsoft Office applications, such as: Microsoft Excel or Word. But don’t know how? Most of the time users take help of a 3rd party converter tool that can perform conversion of DBF files into Word document or Excel worksheet format. As they are not aware of an easy manual trick, they have to use such a paid 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 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:
Step 1: Launch Microsoft Excel on your system.
Step 2: From the Data menu, point to Import External Data, and click Import Data.
Step 3: In the Select Data Source dialog box, click New Source Data Connection.
Step 4: In the Data Connection Wizard, select Other/Advanced.
Step 5: In the Provider tab, select Microsoft OLE DB Provider for Visual FoxPro.
The Connection tab in the Data Link Properties dialog box will be appeared.
In Microsoft Word, follow the steps given below:
Step 1: Launch Microsoft Word on your system.
Step 2: From the View menu, point to Toolbars, and click Database.
Step 3: On the Database toolbar, click the Insert Database icon.
Step 4: In the Database dialog box, click Get Data.
Step 5: In the Select Data Source dialog box, click New Source Data Connection.
Step 6: In the Data Connection Wizard, select Other/Advanced.
Step 7: In the Provider tab, select Microsoft OLE DB Provider for Visual FoxPro.
The Connection tab in the Data Link Properties dialog box will be appeared.
To add a Visual FoxPro database or table folder, follow the steps given below:
Step 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-
Step 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.
Step 3: Specify a different collating sequence if desired.
Step 4: To test the connection, click Test Connection. If connection is successful, click OK.
Database users might be interested in various other topics on Database Recovery & Management.
