Transfer data: Access to MySQL

[wmdrumaizi]

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

Thanks in advance[/quote]

[Oleg Butuzov]

you must use ODBC drivers, your "know how" isnt pratic...