Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    2

    Arrow Unanswered: .csv import to mysql not working ( Problem is Gone )

    Hi

    I have a few excel files, i want to import to mysql, but it will not work propertly, could it be something with the commas ?.

    I get this errors

    > mysqlimport -u root -p -r tabelname path/filename.csv
    Records: 294 Deleted: 0 Skipped: 0 Warnings: 2352
    i have try almost wbery option ... same resault
    or

    mysqlimport: Error: Duplicate entry '2002' for key 1, when using table: tablename

    Total Net Marketing Database Converter - NOT ADDED
    i have try lot of txt, and different .csv files, and it will not working

    All other scripts i have try, tell me the same thing,

    I have 7 Fields in mysql + _id ) i have also test to convert
    from excel to a csv file and edit that file and change info.

    I use This Versions
    Mysql - 3.23.53
    And latest PHP
    Excel 2002 ( XP )

    I have also try this export mysqldata to a .csv file
    with and whitout used characters .... Same resault.

    Have anyone any ide, what i missed, or what i'am doing wrong

    Thanks In Advise
    /bamse
    Last edited by bamse; 12-26-02 at 15:39.

  2. #2
    Join Date
    Sep 2009
    Posts
    64
    Quote Originally Posted by bamse
    I use This Versions
    Mysql - 3.23.53
    And latest PHP
    Excel 2002 ( XP )
    MySQL 3.23? Are you kidding me? Go upgrade ASAP.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •