ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Fox Pro Data Base (https://www.excelbanter.com/excel-programming/306964-fox-pro-data-base.html)

Bob

Fox Pro Data Base
 
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

Fox Pro Data Base
 
http://support.microsoft.com/default...b;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...b;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)


--
Regards,
Tom Ogilvy





"Bob" wrote in message
...
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





All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com