Re: Urgent HELP!!!!

[Martin Pirringer]

first a question... Why not use foxpro directly to send the data?

The above sub has a lot missing so here is just some basic instructions

1.) Open the OLEDB connection to Foxpro
2.) execute the select statement on the foxpro tabel
3.) Load the result into a local cursor
4.) open the MYSQL connection
5,) Loop through the cursor and for each row create a properly formated MYSQL INSERT statement and send it to MYSQL
Something like "INSERT INTO dept ('" + fieldneme1 + "', '" + fieldname2 + ') VALUES('" + fieldvalue1 + "'. '" + fieldvale2 + "')" etc
Then send each one of those rows to the server.

This should work as long as you do not violate any other MYSQL rules like uniqueness of a key field or foreign keys etc.

HTH

Martin
f