Board index   FAQ   Search  
Register  Login
Board index php forum :: Database MySQL Installation

Transfer data: Access to MySQL

Installation and configuration iussues

Moderators: macek, egami, gesf

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
wmdrumaizi
New php-forum User
New php-forum User
 
Posts: 40
Joined: Thu Jan 23, 2003 5:15 pm
Location: Malaysia

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

you must use ODBC drivers, your "know how" isnt pratic...
Oleg Butuzov
Last Samuray
Last Samuray
 
Posts: 831
Joined: Sun Jun 02, 2002 3:09 am


Return to MySQL Installation

Who is online

Users browsing this forum: No registered users and 0 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.