distal-attribute
distal-attribute
distal-attribute
distal-attribute

Import CSV selecting fields

User, date Message
Written by dafi
7 months ago
Category: General
4 posts since Wed, 11 Dec 13
Hi, I have just downloaded HeidiSQL and so far I'm very impressed.

I need to import some data from CSV files to various tables. I couln't find any help file for HeidSQL, only for SQL. Is there any help on the program?

I found the import on the Tools menu but I can't find a way to select which fields in the CSV file I want.

My CSV file has say 8 fields/columns but my table only has 5. It also does not seem to have an option to read the field names from a header row. Am I missing something?

Cheers,
DG
Written by ansgar
7 months ago
4936 posts since Fri, 07 Apr 06
You cannot do that with the CSV import dialog currently. There is just the other way around: deselect columns from the table, when your CSV file has *fewer* columns than the table.
 

Please login to leave a reply, or register at first.