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

Importing Csv Files Into Mysql Database

forums › forums › SQLyog › Using SQLyog › Importing Csv Files Into Mysql Database

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • July 15, 2009 at 7:23 pm #29324
      peterlaursen
      Participant

      What is the program version you are using?

      Actually there are two ways to import a CSV-file:

      1) Using SQL-statement LOAD DATA INFILE

      2) Using ODBC and the Microsoft text-ODBC-driver

      A detailed description of what you do (screenshots etc.) would help.

      If data are truncated that must be because the colums you are importing to are too short.

      Maybe you can attach/paste

      * the CREATE TABLE statement for the tbale you are importing to

      * a sample CSV file. In principle the first 10 rows/lines of your existing file would probably be OK.

      (create a support ticket if you want privacy)

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