Victor
There are quite a few ways to import get data from vfp to Mysql,
the quickest I have found (if you are not using memo fields of blobs)
is to use the mysql command import data from infile.
First create a csv file from your vfp data, and have an existing mysql table, which matches (as close as possible the stru of the vfp table)
then run the import data from infile command.
This command can be called from inside vfp, (using odbc) using sqlstrinconnect() and spt
or create a remote view on the mysql table, and copy record by record data from vfp tables to the mysql table.
A third way, is to use something called dbf2sql.prg which converts the data from a vfp table, to a sql insert series of commands. not really good for working with odbc and this function, as it really used only for a one time data migration.
Feel free to look over my notes and some proceedures posted on a group dedicated to this vfp / mysql
http://groups.yahoo.com/group/vfpmysql/Bob lee
>Is it possible to connect from vfp directly to a mysql database server?
>And if so, how?
>
>I have imported data from mysql to vfp using access (and odbc)
>But i want to know if it is possible to do this directly.
>
>thanks
In the beginning, there was a command prompt, and all was well.