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

    Join Date
    May 2002
    Posts
    8
    Rep Power
    0

    Access tabel to MySQL table


    I am exporting an Access table of about 2300 records to a MySQL table with a MySQL insert statement but only 985 records will export. I have looked at the record 986 in the Access table but nothing is wrong with it. It almost seems as if there is some limitation that it is reaching. ??? Any help would be great.
  2. #2
  3. Big Endian
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    May 2001
    Location
    Fly-over country
    Posts
    1,172
    Rep Power
    29
    Can you export with an Access insert statement instead to see if you get an indication of the problem.

    Open Access.
    Link in the MySQL table using the ODBC driver.
    Do an append query of the Access table to the empty MySQL table.
    Access will pop up a message saying how many records you are about to append, how many will fail (and the reasons they will fail) and do you want to continue.

    Maybe this type of process will help you locate the problem.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2002
    Posts
    8
    Rep Power
    0
    i got the .txt file to upload using a mysql client session. my Access function uses a mysql INSERT command. is this what you mean? what other syntax should i use?
    thanks for the help
  6. #4
  7. Contributing User
    Devshed Intermediate (1500 - 1999 posts)

    Join Date
    Oct 2001
    Location
    New Zealand
    Posts
    1,774
    Rep Power
    24
    I'm sure that I've had this problem before as well, I was trying to import into access and it could only import a set number of characters.

    Possibly the best way to do it would be to run an asp script that builds an sql script and saves it as a file.

    So you would:

    get the table information: fieldnames and definitions.. and build a 'create table' command. Then loop through the records and build an 'insert into' command for each record.

IMN logo majestic logo threadwatch logo seochat tools logo