Dear Glyndower,
> I want to import data into this table from the csv file from excell.
So...i
try to convert the CSV data to Unix format with an editor capable to do
this (e. g. PFE32, ftp://ftp.js-webshop.com/pfe32.zip). I encountered
problems from time to time when trying to import CSV data in Windows
format. Windows has 2 characters for "new line", Unix has only 1
character for this. After converting the import data file (CSV) to Unix
format, importing is never a problem for me.
Hope it helps.
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: "Glyndower" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, July 27, 2001 10:47 AM
Subject: excell text file to mysql table using php admin?
> 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
