General information
Title:
Linking to FoxPro v9 from Access 2003
What I'm trying to do is the following.
We have a project management Foxpro application that stores data in 6 separate folders (free tables). We need a program wide report that combines the 6 projects.
I'm using Crystal for reporting. I started by simply linking the FoxPro tables in MS Access (.mdb) using ODBC then created a union query that combined the various project tables together. That scenario never require the user to open the Access database, just running the Crystal report. Access is just used as a go-between.
Everything worked fine until I noticed that Access returned different results on every run. I later learned that ODBC is not supported for VFP beyond v6.
What I would like is to be able to link to the FoxPro tables via OLEDB just as I was linking via ODBC. This mechanism is available in Excel as well as in Word. Why in the world is it not available in Access?
Or I just do not see how to?
I need help quite badly!
Germain
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only