Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
104
Views
Topic starter
I am trying to use Power Pivot to extract and analyse data from a Visual Foxpro 9 database. However, trying to connect to the database is proving challenging. Has anyone managed to do this and, if so, how? I hope my query is appropriate to this forum - please redirect if appropriate.
Posted : 06/04/2019 12:52 pm
Hi Jim,
Welcome to the forum!
You might run into problems because Visual Foxpro is no longer supported. However, you can try getting the data with Power Query using an ODBC/OLE DB driver. This post has some links to Visual Foxpro 9's drivers. Tip: make sure if you're running 64-bit Excel that you get the 64-bit driver and vice versa for 32-bit.
Mynda
Posted : 06/04/2019 6:05 pm
