AW: Load Data from *.csv File

[H. Michael Mai]

> -----Ursprüngliche Nachricht-----
> Von: Markus WOlf [mailto:mwolf_(at)_suedstern-ag.de] 
> Gesendet: Donnerstag, 29. August 2002 17:14
> An: mysql-de_(at)_lists.4t2.com
> Betreff: Load Data from *.csv File
> 
> 
> Hello!
> 
> I use phpmyadmin 2.2.0 and would like to import an ascii-file 
> into one of my database-table.
> 
> The text-file is generated from ms-excel and creates a csv 
> -file (limiter is the semicolon) two rows: 
> 1. row: Number 
> 2. row: assigned name
> 
> 
> My target taget table consist out of three rows
> 1. row: autoincrement number
> 2. row: number
> 3. row: assigned name
> 
> How can I import the asci-file correct into the database?
>  Every time I use phpadmin it produces following output:
> LOAD DATA LOCAL INFILE 'C:\\WINNT\\TEMP\\phpDA.tmp' INTO 
> TABLE `transfer_supplier` FIELDS TERMINATED BY ';' ESCAPED BY 
> '\\' LINES TERMINATED BY '\\n' 
> and afterwords I see that just one row is imported.
> 
> Does anyone have an idea how I can get further?
> 
> Thanks
> Markus
> 


Hi markus,

I suppose your *.csv file is created on a windows machine?!

In this case try :   .... LINES TERMINATED BY '\r\n' 

Hand

Mike


  Mit freundlichen Grüßen / with kind regards

     H. Michael Mai
 
  Project Group Manager E-Services
________________________________________
Medien-Service Untermain GmbH
Fon +49 - (0)6021-396 432
Fax +49 - (0)6021-396 155
Mobile +49 - (0)170 - 9911655
Weichertstraße 20
D-63741 Aschaffenburg
E-Mail: mailto:mai_(at)_medien-service.net
WWW: http://www.medien-service.net
_________________________________________
HRB 2996 Aschaffenburg
Geschäftsführer: Ulrich Eymann, Reinhard Golembiewski, Dr. Helmut
Teufel, Eric Dauphin
_________________________________________
Diese E-Mail kann vertrauliche und/oder rechtlich geschützte
Informationen enthalten. Wenn Sie nicht der richtige Adressat sind oder
diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den
Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie
die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If
you are not the intended recipient (or have received this e-mail in
error) please notify the sender immediately and destroy this e-mail. Any
unauthorised copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.

---
Infos zur Mailingliste, zur Teilnahme und zum An- und Abmelden unter
-->>  http://www.4t2.com/mysql