Can anyone please tell me how I can convert FoxPro Database to MySql
Thanks

u want to use foxpro technology or MYSQL.B-coz from both the ways i.e. fm foxpro to mysql and vice-versa is possible.

Are you asking if a FoxPro executable can access a MySQL database? If so, it can if the machine that the exectuable is running on has an ODBC driver for MySQL and if you can change either the DSN or the connect string for the FoxPro program.

If you are asking if the data in FoxPro DBF files can be imported directly into MySQL, the easiest way is to use a FoxPro program to do it.

-PatP

Try converters at dbconvert.com

if there is not a native converter (you could try dbtools.com), then the only other route I can think of may be to migrate the data to Access, or write a custom update /data take on routine.

From VFP, you can connect to MySQL and do just about anything you need to. For any differences in the SQL syntax, you can start here: SQL implementations, database servers, and VFP Tod means Fox

I can post you some code examples if you need a head start.