ADO and MySQL (without BDE)

From: ascll (ascllREMOVE_at_yahoo.com)
Date: 05/28/04 

Date: Fri, 28 May 2004 14:54:03 +0800

Greetings,

By using ADOConnection, ADOQuery and make use of FoxPro ODBC driver as
'ConnectionString', how to I extract all the records from FoxPro table
(test.dbf) to a text file (test.txt), and this text file should be imported
to MySQL table (same table structures) using command below: -

LOAD DATA INFILE "text.txt" INTO TABLE 'mysql_tablename';

Or you you have alternative methods to import records from .dbf table into
MySQL table using only ADO components (NO BDE components)?

Thanks in advance.