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

    Join Date
    Mar 2000
    Posts
    1
    Rep Power
    0
    Hi folks. I'm a newbie at online databases & I'm having problems. I've got MyODBC installed on my PC and my hosting company has MySQL installed on their server.

    I have an access database that I want to export from. However, when I try and do this all I get is "ODBC - Call Failed
    [Microsoft] [ODBC Driver Manager (#0)
    " in Access.

    I'm using Win2K Professional & Access 2000.

    Any ideas what's up and how I can solve it? It's driving me mad!

    Regards,

    Kevin
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Posts
    2
    Rep Power
    0
    Kevin,
    I'm having the same problem. Although I was able to import from mySQL into Access. Did you find a solution ?
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Posts
    7
    Rep Power
    0
    I'm having the same problem! With Win98 & Access 2000 I can import but not export tables.
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    3
    Rep Power
    0
    Well, I am having the same problem.
    I know this message doesn't help, but if anyone finds a solution. HELP.
  8. #5
  9. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    1
    Rep Power
    0
    Hey folks, I had some major problems with this too. I tried some of the export scripts that I found around the net, but none of them worked for me.

    So, I recreated each table definition (which is very useful to have now for backup) in MySQL, and then cut & paste all my old data into the new tables via Access 2000.

    Here's my setup:
    - win2k server
    - latest MySQL (as of yesterday)
    - latest MyODBC ODBC driver
    - access 2000

    Here's what I did:
    - installed MySQL and created a db
    - created the table definitions (as mentioned above... yeah it was a lot of work for the 1st few tables, but then everything was cut & paste after that)
    - created an ODBC link to my new MySQL database (set it up as a System DSN as opposed to a User DSN)
    - open up Access 2000, and selected FILE->OPEN. (then select the filter drop down box and select the last option ( ODBC Databases() )
    - then open up your MySQL database that you just setup in ODBC
    - then select all your tables to import
    - then hit FILE->GET EXTERNAL DATA->Link Tables and select your original Access db that you want to migrate your data from.
    - then open up one of the tables that you've linked to in your Access db, select all the records, Copy them, and paste them into the corresponding records of the MySQL table.

    A lot of work ( a couple of hours ), but now all my data is over in MySQL.

    :-)

    I hope that helps SOMEONE! ;-)

    //stevek

Similar Threads

  1. Errcode:13 . How to solve it on MySQL + Windows 2000
    By hankycheng in forum MySQL Help
    Replies: 28
    Last Post: August 3rd, 2003, 10:05 AM
  2. SSL MyODBC Port Forwarding Problems
    By helpmeplease in forum MySQL Help
    Replies: 1
    Last Post: June 23rd, 2003, 08:18 AM
  3. Replies: 0
    Last Post: May 7th, 2001, 02:07 AM
  4. MySQL PHP problem
    By The Pie Man in forum PHP Development
    Replies: 6
    Last Post: April 24th, 2001, 05:17 PM
  5. Tutorials or Information re: Access/Paradox, MyODBC and MySQL
    By Robert_J_Sherman in forum MySQL Help
    Replies: 0
    Last Post: December 16th, 2000, 06:01 AM

IMN logo majestic logo threadwatch logo seochat tools logo