Can MSAccess97 import FileMaker dbase? 3

[elaun]

I work in a hospital providing I.T. support to clinicians. MSAccess97 is the desk top standard. I recently was requested to evaluate if a FileMaker database can be imported into MSAccess97.

Has anyone encountered/done this before? Thanks...

 

[JoeMiller]

There is no native filemaker import support, but if the filemaker file is on a windows accessible server you can use an ODBC connection to get at the data and then import it. Look up "FileMaker ODBC driver" on google and see what you get.

HTH Joe Miller
joe.miller@flotech.net

 

[CosmoKramer]

You can also export the filemaker files to text files(.csv, .tab, etc.) and import them into an Access table. I've done this several times to convert databases to Access and it works great.

 

[jbento]

You can create a text file from the Filemaker Pro database, and then import that text file into Microsoft Access 97. I have done this before. Make sure you already have a table in Access that has the same fields coming from Filemaker Pro, then import directly into that table in Access. I hope this helps.