Fox Pro Data Base

[Guest]

I am having great dificulty in getting my external data to create piviot
tables. I can complete the process on NT systems, but I just got this new lap
top and Excel will not let me extract information from Fox Pro tables / data
base. It doesn't even show in the Data type selection drop down.

How can I correct this?

Bob

 

[Tom Ogilvy]

http://support.microsoft.com/default.aspx?scid=kb;en-us;225861
No options are available to import, link, or export to the FoxPro file type
in Access 2000

The above is for Access, but should be equally applicable to your situation.
It tells how to install the
Microsoft Visual FoxPro ODBC driver

This article is actually better:
http://support.microsoft.com/default.aspx?scid=kb;en-us;197893
HOW TO: Use Visual FoxPro DBC Files in Microsoft Access 2000

It also has a link to download the MDAC which contains the driver.

(In XP, the Icon for this is under administrative tools in the Control
Panel)