#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Posts
    47
    Rep Power
    11

    Exporting data from MS Access to MySQL


    Hi

    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???
  2. #2
  3. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,616
    Rep Power
    4247
    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

IMN logo majestic logo threadwatch logo seochat tools logo