Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Import: map fields

chris.cavage's profile image chris.cavage posted 3 years ago in Import/Export Permalink

I thought there was a way (or once a way) to import a file (.csv, .xls) and upon importing, I could map the file columns to the database table rows. Is that feature available?

I have a lot to import and the columns don't always match my table rows but I need to import them to appropriate new fields anyway.

Thanks!!

ansgar's profile image ansgar posted 3 years ago Permalink

Not with HeidiSQL. The table has to be created when you import a csv file.

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