Transfer data: Access to MySQL

A

Anonymous

Guest
Hi, I'm using PhpMyAdmin to transfer my data from MS Access 2000 to MySQL table.

For your information, my MySQL table and Access table name is maintable and I've saved the Access table as maintable.txt.

When I press Submit I got this error. Could someone please tell me how to solve this error and what is 'c:windowsphp148.tmp' file.

Database researchers - table maintable
Error
SQL-query:

LOAD DATA LOCAL INFILE 'C:\WINDOWS\php148.tmp' REPLACE INTO TABLE maintable FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\n'
MySQL said: File 'c:windowsphp148.tmp' not found (Errcode: 2)
Back
Click to expand...

Thanks in advance[/quote]
 
You must log in or register to reply here.
Back
Top