How to export from FM 7 to MySQL

[Seinn]

I have a major problem and need some help quickly. The situation is we have gathered a lot of onformation for a community website and have all this info stored in a Filemaker 7 Database. The website that is being developed for us is running on the Mambo open source solution which calls on a MySQL database. I need to be able to eprot all out Filemaker database to SQL but sadly this feature is not included in FM7. When I use the other export options the resluting data gets messed up with weird characters. Does anyone know of a way to export Filemaker to SQL or convert from Filemaker to SQL? Any help will be very much appreciated.

[Reed]

Tab-delimited or csv should both easily be exported/imported from FM to MySQL. If you want to use SQL to upload the data to a MySQL server, you can use Filemaker's Execute SQL script step. (INSERT * etc)

[transpower]

Use ODBC.

[bruceR]

You can also use applescript. Search VersionTracker for MySQLBridge.