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.

No rows imported error

cat210803's profile image cat210803 posted 2 weeks ago in Import/Export Permalink

I'm trying to import a simple csv file into an empty table. I haven't done this before.

No rows were imported. This can have several causes: -File is empty -Wrong file encoding was selected or detected -Field and/or line terminator do not fit to the file contents

I've attached screenshots of both my import settings and my file; can anyone tell me what I'm doing wrong? (I did see another topic on this, but it's quite old

2 attachment(s):
  • Capture
  • Capture2
ansgar's profile image ansgar posted 2 weeks ago Permalink

I see the file has commas as field separators, not semicolon as you specified in the dialog. Also, there is no encloser character, so you should make it empty in the dialog. Last bit is to check the line break style in the file. Your Notepad does not show the style, so you should check that with Notepad++.

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.