#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    3
    Rep Power
    0

    I installed the MySQL driver, configured the DNS to connect to my server. I keep getting this error message:
    ODBC -- call failed
    [Microsoft][ODBC Driver Manager (#0)
    Can anyone guide me into the steps needed to
    export a table from Access to MySQL Database.
    Thank You.
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62
    If you just need to export occasionally, it's not worth the trouble setting up ODBC. Just export from Access as CSV or tab-delimited and import into MySQL. It takes a bit of reading to do it the first time, but that's what documentation is for.

    A way to make it a bit easier is (if you have PHP installed) go to www.phpwizard.net and download phpMyAdmin, which is a web-based front end for MySQL and facilitates importing and exporting, among other things.

Similar Threads

  1. Replies: 2
    Last Post: September 22nd, 2003, 01:28 PM
  2. optimize MS Access using MySQL
    By ambrosio_98 in forum MySQL Help
    Replies: 1
    Last Post: May 26th, 2003, 06:43 AM
  3. Access --> MySQL on a regular basis
    By kappaluppa in forum MySQL Help
    Replies: 1
    Last Post: March 24th, 2003, 01:58 AM
  4. [ADV] MS Access Export to MySQL Tool
    By customfittech in forum MySQL Help
    Replies: 7
    Last Post: March 1st, 2003, 04:20 PM
  5. I can not export M.S. access databases to MySQL.
    By seanma in forum MySQL Help
    Replies: 0
    Last Post: August 24th, 2000, 12:11 PM

IMN logo majestic logo threadwatch logo seochat tools logo