I had a similar problem (huge-ish legacy DBF tables that need to be transferred daily). I use a program called cdbflite to create text files from the DBF tables (you can pass a SQL string to the program if you only want a subset of the data), and then bulk load into MySQL. Even with the extra step, it's fairly quick, and the whole process is batch-able. Check http://www.whitetown.com/cdbflite/ for info.
Cheers, Jim > -----Original Message----- > From: root [SMTP:[EMAIL PROTECTED]] > Sent: Monday, January 14, 2002 12:55 PM > To: [EMAIL PROTECTED] > Subject: DBase IV to MySQL > > hi! > i have to transfer weekly about 600k records from dbf file to remote > mysql server. > anyone have an idea where to find some libraries to access dbase in > delphi/kylix ? > the standard bde engine is very slow on lorge dbf tables > > thanks > > blestan > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
