Hi;

What's the best way to transfer VFP data into Mysql?

Some of the tables I need to do this contain 100,000 records. I was
wondering what would be an efficient way to do this - ODBC, or some
other trick?

thanks,

AK.

If the tables are identical, just export your table to some in-common
format (ascii delimited or whatever). I use MySql Control Center and
there is an import utility. Pick the table and go. 100K records
won't take much time. Make sure when you create the MySql table you
don't do any indexing until AFTER the table is loaded or it will slow
you down considerably.

mj