Import CSV selecting fields

[expired user #7481]'s profile image [expired user #7481] posted 11 years ago in General Permalink
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's profile image ansgar posted 11 years ago Permalink
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.