Setup Microsoft Excel for Vision 3 Searches

This procedure only needs to be performed once.
However, if you change computers you will have to perform this procedure again, because we are going to set up a local path (folder) from Vision to Excel.

If you are using a PC with Microsoft XP (only) you will have to install a FoxPro ODBC driver first, follow this link: http://msdn.microsoft.com/en-us/vfoxpro/bb190233.aspx and download this driver “VFPODBC.MSI” in English.

When downloaded, double click the file and it will install the correct driver, just accept all the questions.

Then…

1. Open Microsoft Excel

2. Click on the Data menu – Get External Data – New Database Query…

If you receive this message

Put your Microsoft Office CD into the CD drive bay and press the Yes button. This will install Microsoft Query.

Then continue…

3. Press OK (make sure that <New Data Source> is highlighted)

4. Type in details of the Data Source i.e. “Vision Extract Folder”

5. Now choose the driver “Microsoft FoxPro VFP Driver (*.dbf)”

6. Now click the Connect… button (this sets up a connection between the contents of the local and a folder of your choice, i.e. C:\Extract folder and Microsoft Excel Query)

Choose “Free Table directory” and click on the Browse button to locate your “extract” folder or type in the location in the Path text box as shown above is on a LAn site while below is a remote site setting. Then press the OK button

7. Press the OK button again when it looks like the example below;

You have now linked the MS Query Data source to the Extract folder, and you won’t have to do this again unless you use a different PC.

All you will do in future is highlight the line “Vision Extract Folder” to enable you to import Vision search data located in the Extract folder.

Alternatively you can just connect to a data source directly every time

1. Open Microsoft Excel

2. Click on the Data menu – Get External Data – New Database Query…

3. Select Visual Foxpro Database or Tables and click OK button

 Click on the Browse button to locate your “extract” folder or type in the location in the Path text box as shown above is on a LAn site while below is a remote site setting. Then press the OK button

This will now show you the content in your select folder. Then choose the columns you want to merge by expanding the tables and follow the screen prompts...

Further instructions are shown on other pages and documents through out this website, like Merging a Vision DBF export in Excel or ...use VLOOKUP formula in Excel