Helpful Information
 
 
Category: Database Management
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.

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.

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

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.










privacy (GDPR)