SQL server Import CSV file - 1'st row is also added as s column name

Question

I'm trying to import a CSV file using import export wizard, Im facing an issue. The first row is also added as a column name.

Import wizard:

enter image description here

The highlighted area is my 1'st row.

• Stijn Wynants: What is your row terminator?
• TheDataGuy: THis is my row delimiter {CR}{LF}
• Stijn Wynants: can you check if the csv file first row has the CRLF at the end?
• TheDataGuy: I have attached the snap in my question, can you check whether it has or not?
• Stijn Wynants: I can't do it from a snap :), copy the first two rows when opening in notepad, and check if there is a CRLF at the end, if not that is your issue.

Answer 1

I used your data and was able to do it without any issues. Seems your first row of data does not have {CR}{LF}. The snap of data looks like there is an auto new line rather than you providing it.And that is why the 3rd column has ' Is_Active""1, so the wizard is looking for a comma now. Below is my test with data of similar type :

enter image description here

enter image description here

enter image description here