Transfer data between Access and FMP

[rmsherman]

What is the easiest way to transfere data back and forth between a Filemaker 5.0 and the Microsoft Access Database? To what extent can scripts be employed? Thanks for you help.

[BobWeaver]

Except where one of the programs can directly read/write the other's native format, my preference is always to import/export tab delimited files since this format is supported by most applications and is fairly foolproof. You can use the import and export steps in a Filemaker script to automate the Filemaker end of things. Do an export (or import) manually first. Select the fields that you want to export (or import) in the dialog box. Then, when you choose the Export Records (or Import Records) script step, the script will use and store the same field order as your last manual export (or import).

As for Access, I expect you should be able to do the same.