Hi!

Im trying to import an excel csv file into a mysql db, i'm using the load data mysql command like this:
LOAD DATA INFILE "codigos.csv" INTO TABLE CIUDADES (CIUDAD, CODIGO) FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'
but it doesn't work, i think this happens because the excell carriage return is not the '\n'. Could somebody help me?
thanks for all!
Sorry for my bad english!
José Sabbagh.

    i use de phpmyadmin to import the csv file into mysql, but this just import the first row of my csv file.
    Could somebody help me?
    José Sabbagh

      Probabley you should rename your table CIUDADES to codigos (from your csv file name)

        Have you tried "LINES TERMINATED BY '\r\n'" clause?

          Write a Reply...