August 2nd, 2004, 07:56 AM
Exporting data from MS Access to MySQL
im trying to automatically transfer some data from a Ms Access Db to a MySQL.
I connect to them both using ODBC and i know the query i want to get the correct data, but where do i go from there.
i want to get field1, field2, field3 in table1 in MS Access to field4, field5, field6 in table2 in MySQL
Does anyone have any tips for me???
August 3rd, 2004, 12:39 AM
Have you tried using the TBatchMove component under the BDE tab?
Up the Irons
What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
"Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
Down with Sharon Osbourne
"I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo