Access 97-FileMaker Pro Mac OS X

[William Block]

How do I import data from an Access '97 database using ODBC to FileMaker 6,7 or 8 Advanced? I can do this easily using Windows XP and FileMaker 6--but I haven't figured out how to do it--or if it's possible to do it using OS X.

Thanks in advance!

[Zero Tolerence]

First, do you have an ODBC Driver installed on your mac? Once you install the driver it shouldn't be much different.

[Wim Decorte]

If this is a one-off thing, just export the data from Access and import into FM.

[William Block]

Unfortunately this is a regular process involving moving data from the Access Data file to a FM Database. And I am usually performing this from a remote mac without access to MS Access for the export.

[William Block]

I am pretty sure I have an ODBC driver installed.. the one from DataDirect?? But, I don't see a MS Access to FileMaker ODBC driver..?? Am I missing something?

Thanks!

[David McQueen]

How do I import data from an Access '97 database using ODBC to FileMaker 6,7 or 8 Advanced? I can do this easily using Windows XP and FileMaker 6--but I haven't figured out how to do it--or if it's possible to do it using OS X.

Thanks in advance!

I can't say for FMP6, but I have just been working with FMP7/8 - There is no OBDC link from FileMaker OSX to ODBC sources. You must have FileMaker on a Windows Box. Also, the abiliteis to call a VB script differ between using FMP7/8 and Advance Server.

HTH

Dave McQueen