Hi!. I've been working on a project to import data from a contact management system into a Filemaker 7 database but hit a brick wall at the moment. The 3rd party application (SQL server based) contains contact information that needs to be imported as a point in time snapshot to mapped fields within the FM database. At the moment I've been working on a theory of exporting the contact data to the local clipboard and then importing via script to a new record in FM but haven't been able to work out how to do it. Ideally I don't want to have to export to a file and then re-import, but run it on the fly.

Has anyone out there any ideas or pointers?

Will you be importing a single contact record at a time or will it be multiples? Also, will everything be going into a single table or multiple tables?