Does anyone know how to export a FileMaker Pro Database so that MySQL can use it? Anyone ever do something like this?
If you want a one-time transfer, the simple and cheap way is through some sort of text file; CVS or tab-delimited, for example.
If you want the two databases to collaborate on a single set of data, it's best to give MySQL the canonical copy and let FileMaker manipulate it through ODBC.
If the data doesn't change very often, you can use FileMaker's built-in ODBC support. Just write a script to pull a copy of the data you want, manipulate it in FileMaker, and then you can export a copy through a text file as above.
If the data changes often or you need online manipulation of the data, you can add a SQL plugin to FileMaker. Do a Google search, you'll find them. There are at least two of them on the market, as I recall. They're about $100 for a single seat, with site licenses available.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
