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

Csv Import – Automatic Field Mapping?

forums › forums › SQLyog › Using SQLyog › Csv Import – Automatic Field Mapping?

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • July 14, 2010 at 5:36 am #31090
      Khushboo
      Member

      Hi Todd,

      There is no way to check how many columns are there in the CSV file through Import CSV Data using LOAD LOCAL as it simply executes a data manipulation statement “LOAD DATA INFILE” to import.

      For you case, you can import CSV File through Import External Data wizard. Through Import External Data –> Column Mapping Section you can check which fields you want to import from CSV and the target table. Also, in Advanced Options select “Import into existing” option. Please see the screenshots and you can also go through program's help menu.

      Thanks & Regards,

      Khushboo

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