I have a database table in Access (or I can convert to to an Excel spreadsheet) that I need to import into MySQL...but with a catch...the fields will not be called the same thing or in the same order. What is the best way to go about doing this?
Are the Access and MySql DB's on the same machine? If so, then install MySql ODBC. Then in Access create linked tables to the MySql database. Write whatever SQL necessary in Access to insert data into the linked tables.
