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.

Multiple columns csv data are imported as a single column.

tulgaerdene's profile image tulgaerdene posted 3 weeks ago in General Permalink

I have a CSV file that has 6 columns such as Phone, Source, Leadtype, Email, Date, State. When I import this CSV into a new table, all columns are imported as a single column. I attached the screens of CSV, Dialog, Result.

3 attachment(s):
  • 2022-01-11_18-48-18
  • 2022-01-11_18-48-32
  • 2022-01-11_18-49-54
ansgar's profile image ansgar posted 3 weeks ago Permalink

You are using the CSV layout detection with a wrong field terminator: you specified semicolon ";" while the file seems to use comma ",".

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




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.