>>>>> On Mon, 22 Apr 2002 12:23:22 -0400, Mark Riehl ><[EMAIL PROTECTED]> said:
MR> All - We've got several Access databases that have ~2 million records and MR> each record has ~20 fields. MR> Looking for the most efficient way to do this. As far as I can tell, I have MR> two options: MR> 1. Open a connection to each database, select * from the Access table, then MR> push each row into MySQL. MR> 2. Export the table from Access, then use a load data file to pull it into MR> MySQL. Each of the exported files is ~ 1 GB. MR> Any other suggestions? How would you do this? Visit http://www.mysql.com/downloads/contrib.html It lists some tools which do Access -> MySQL conversion. -- Ilya Martynov (http://martynov.org/)
