Importing bulk existing data into separate existing sql db
Posted: Tue Oct 21, 2008 6:19 am
I have an Access file, and a MySQL database.
I need to import that data from the Access table into the existing MySQL table.
Some fieldnames differ, but I can alter them in Access before I do anything.
I'm assuming it's be some kind of "INSERT" query, but I've never done it with a bulk of existing data into a query.
Can anyone help please?
I need to import that data from the Access table into the existing MySQL table.
Some fieldnames differ, but I can alter them in Access before I do anything.
I'm assuming it's be some kind of "INSERT" query, but I've never done it with a bulk of existing data into a query.
Can anyone help please?