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

Import CSV selecting fields

dafi posted 1 year ago in General
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
ansgar posted 1 year ago
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.