Hi;

Anyone here worked with exporting data from dbf to mysql? I don't want
to work with odbc cause it's slow.
Any ideas how to move large amounts of data from a win based vfp table
into a Linux based mysql table?

Thx,
AK

On Tue, 08 Mar 2005 19:23:49 GMT in comp.databases.xbase.fox, AK
<newal (AT) rugwho (DOT) com> wrote:

save the data as CSV files. i believe most SQL servers allow
import of flat files. of course, you will have to create the
table by defining a database with a schema that matches your
original vfp tables.


To send an email, remove the nospam...

AK wrote:
I wrote a foxpro program some time ago that re-creates a table & all the
data in SQL by generating a text file with CREATE TABLE and INSERT
statements. It was designed for MS SQL 2000 but there was nothing
special about the generated SQL. I used it to transfer 100s of
Megabytes of data.

Let me know if you want a copy.

--
Paul

look at the gendbc program in the tools directory

"AK" <newal (AT) rugwho (DOT) com> wrote