ISAM for FoxPro 2.6 tables linked into Access 2003

[CC99]

I have been running queries and reports with data from our company database (a third-party system based on FoxPro2.6) by linking tables into MS Access 97 for years. We have now upgraded to XP and Office 2003, and suddenly I can no longer do this but get a message "Could not find installable ISAM".

I've tried to locate the required file on the Internet but no luck so far. Can anybody help me? I am currently using an old pc with Office 97 on it to run the reports, but it's in a different office location and makes the whole job very tedious. Are there any work-arounds?

Any help much appreciated!

CC99

 

[Angus_NB]

You don't need an ISAM. Just link to the FoxPro tables using ODBC.

 

[CC99]

OK, this is embarrassing now, other than selecting Link to Table, I haven't a clue how to do this. I know in general what ODBC is about, but I don't know how to work with it. That's probably too much for here, but do you know a link to some pages that can help me with that? Your assistance is greatly appreciated.

cc

 

[Pat Hartman]

You don't really need to learn anything special except that you'll need to set up a DSN to get to the FoxPro db. Once the table is linked you can work with it pretty much as you would work with any other table.

File/Get External Data/Link
Change the file type to ODBC
If you haven't already set up a DSN, this is where you'll create one. If you have one, you would just choose it.
Switch to the Machine Data Resources tab and choose New
Click Next and on the second page of the dialog, choose the FoxPro driver from the list. If the driver is not here, you'll need to go back to the Office installation CD and install it before you can continue.
I don't have the latest FoxPro driver installed so this is as far as I can go but the wizard should walk you through the process. Eventually you'll be asked to choose a FoxPro database and give it a name. This is the name you'll choose from the list next time rather than pressing the new button.