All - We've got several Access databases that have ~2 million records and each record has ~20 fields.
Looking for the most efficient way to do this. As far as I can tell, I have two options: 1. Open a connection to each database, select * from the Access table, then push each row into MySQL. 2. Export the table from Access, then use a load data file to pull it into MySQL. Each of the exported files is ~ 1 GB. Any other suggestions? How would you do this? Thanks, Mark - Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED]
