Try this
save any file format to .csv and use this statement in your program
load data local infile 'c:\\dir-in-harddisk\\filename.csv' into table
hr.trn fields terminated by '\,'
this command was in MySQL Manual
Sommai Fongnamthip
At 04:47 27/7/2001 -0400, Glyndower wrote:
>Hi,
>
>I'm using PHP Admin 2.2.0pre5 (unofficial stable-branch)and MySql 3.22.32
>
>I have created the following table:
>
>Field Type Attributes Null Default Extra Action
>agent_id smallint(6) No 0 Change Drop Primary Index Unique
>first_name tinytext No Change Drop Primary Index Unique
>last_name tinytext No Change Drop Primary Index Unique
>email_address tinytext No Change Drop Primary Index Unique
>area_code tinytext No Change Drop Primary Index Unique
>area tinytext No Change Drop Primary Index Unique
>have_picture tinytext No Change Drop Primary Index Unique
>about text No Change Drop Primary Index Unique
>
>I want to import data into this table from the csv file from excell. So...i
>"insert textfiles into table" , browse to the .txt file on my harddrive,
>select "replace", feilds terminated by "\t", feilds escaped by "\t" , lines
>terminated by "\r",
>
>the I hit "submit and get....
>
>Error
>MySQL said: Query was empty
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
