Transfer data: Access to MySQL

Installation and configuration iussues

Moderators: egami, macek, gesf

Post Reply
User avatar
wmdrumaizi
New php-forum User
New php-forum User
Posts: 40
Joined: Thu Jan 23, 2003 5:15 pm
Location: Malaysia
Contact:

Tue May 27, 2003 12:34 am

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]
Thanks and regards;
wmdrumaizi

Oleg Butuzov
Last Samuray
Last Samuray
Posts: 824
Joined: Sun Jun 02, 2002 3:09 am

Wed May 28, 2003 12:30 am

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

Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest