Transfer data: Access to MySQL

Installation and configuration iussues

Moderators: macek, egami, gesf

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

Transfer data: Access to MySQL

Postby wmdrumaizi » 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]

User avatar
Oleg Butuzov
Last Samuray
Last Samuray
Posts: 831
Joined: Sun Jun 02, 2002 3:09 am

Postby Oleg Butuzov » Wed May 28, 2003 12:30 am

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


Return to “MySQL Installation”

Who is online

Users browsing this forum: No registered users and 0 guests