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
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)
Thanks in advance[/quote]