Link to Filemaker Pro frpm Access?

[ckiley]

Our organization has a very old Filemaker Pro database, and no one here has any experience with Filemaker. We need to pull out all the data and put it in our Access database. Unfortunately, from Filemaker, we get a different number of records each time we do the same export.
I am trying to figure out if I can connect to the tables from Access, and get to ALL the data that way. I tried setting up an ODBC connection to filemaker in the Admin Tools and tried linking to a table in FMP from Access but got an error that it failed to connect to the FMP database and failed to get a list of tables.
Has anyone had experience trying to connect to a FMP database? Can you connect to one from Access? This thing is kind of a black box to us, and we want to pull out all the data, but can't seem to get to it. Any guidance would be appreciated!!

 

[Scooterbug]

Are the ODBC drivers for the correct FMP version?

Other ideas: Can you export the tables into a text or csv file format? If so, you can export the data, then reimport it.

 

[ckiley]

How do I check the drivers?

We've tried exporting from Filemaker to a text file, but we don't get all the records. The same export produced a different number of records each time we ran it, so we don't trust FMP's export.

 

[Scooterbug]

In Control Panel --> Administrative Tools --> Data Source (ODBC) you should see a list of ODBC drivers installed on the system. You need to make sure that the driver version supports the version of FMP that the data is in.