On Wed, 2004-04-28 at 12:08, Rod wrote: > I have seen some commercial programs that do the job, but they don't seem to > explain what they actually do. Ideally, I would like to import the data > into Filemaker and then I can create a front end and scripts to manipulate > the data.
Yup; all you need to do is to get Access or Microsoft SQL Server (I assume that's what you mean by "SQL", as "SQL" is a database query language standard) to dump the tables in a general format like "CSV". The MS access client can probably do this for you, though I'm afraid I don't know enough about it to give detailed instructions. This won't give you the table definitions or the front-end, but it will give you the data in a format that can be imported into FileMaker. You can then create empty tables with the same format in Filemaker, and import the CSV files of each table. You may even be able to tell FileMaker to import the CSV file and have it create the table format for you. I've done it in the other direction more than a few times while migrating from FileMaker to PostgreSQL. There are probably programs out there that simplify translating the table formats, etc, but IMHO it's not too hard to do manually. Just make sure to dump or print out plain text copies of the table format definitions as well as bringing the data files. Craig Ringer
