Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Import Data From Csv Problem

forums › forums › SQLyog › Using SQLyog › Import Data From Csv Problem

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • September 21, 2005 at 11:59 pm #9241
      skygxproject
      Member

      I have a simple CSV file with two columns and 81 lines. The fields are delimited by a comma, each of the column's data (which is all just text) are surrounded by quotes, and each line is terminated with a newline character. When I attempt an import of this file into a table that has just the PK and two columns to accept the two columns from the CSV (remembering to select from the list of columns the names of only the two columns I want to import), the program gives me warnings on every row that it was truncated because there were more data than there were input columns. Well, that's just not true. The CSV file is perfectly kosher, and my table is constructed to accept it. Attached is the CSV file I'm using (with the .csv extension changed to .txt so that I can legally attach it here). Now tell me, doesn't the file look just fine to you? I've got to be missing something here. Please help.

    • September 22, 2005 at 12:14 am #19251
      peterlaursen
      Participant

      It imports perfect here with attached settings.

      Both columns imported to were created as varchar(255)

    • September 22, 2005 at 3:41 am #19252
      skygxproject
      Member

      Well, those settings worked perfectly! Thank you very much. Now I just need to make sense of why those setting DO work.

      -Christopher

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.