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

    Join Date
    May 2000
    Posts
    1
    Rep Power
    0
    I have seen other similar posts but I have not seen any final answers. I'm at the pulling my hair out while screaming point. I cannot get Access2000 to export data to MySQL to save my life. It keeps giving me this error: Information type of of range #0.
    It also at one point was continually giving me the call failed #0 error I've been seeing posted too. As a note, MySQL is installed on an NT4 Server and I'm working from an NT4 workstation. I have not set up any users - only root with no password is available.

    [This message has been edited by hardroc (edited May 23, 2000).]

    [This message has been edited by hardroc (edited May 23, 2000).]
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    9
    Rep Power
    0
    I am a newbie and Use Access 97, but when I import to DB I do the following and see if it will work for you.

    I make sure columns are named and ordered the same in each database table.

    I export from Access as .txt without the column names.

    From there I can usually import into the DB table.

    ------------------
    Terry Thon
    terry@biz-1.com
    (Databases, Cold Fusion Web Applications)

Similar Threads

  1. MyODBC Silent Installation... Please Help !
    By Techie in forum MySQL Help
    Replies: 16
    Last Post: June 10th, 2004, 03:53 PM
  2. iis log files - query about 404 errors
    By u230503 in forum IIS
    Replies: 0
    Last Post: December 10th, 2003, 04:25 PM
  3. Replies: 2
    Last Post: October 26th, 2003, 12:14 PM
  4. Installed PHP with IIS, but get a notice.
    By PushPad in forum PHP Development
    Replies: 5
    Last Post: June 1st, 2003, 08:45 PM
  5. request for php.ini
    By Thomas Sauer in forum PHP Development
    Replies: 1
    Last Post: June 29th, 2001, 02:20 PM

IMN logo majestic logo threadwatch logo seochat tools logo