BULK INSERT not inserting properly from CSV
<p>I am trying to use <code>BULK INSERT</code> to add rows to an existing table from a .csv file. For now I have a small file for testing purposes with the following formatting:</p>

<pre><code>UserID,Username,Firstname,Middlename,Lastname,City,Email,JobTitle,Company,Manager,StartDate,EndDate
273,abc,dd,dd,dd,dd,dd,dd,dd,dd,dd,dd
274,dfg,dd,dd,dd,dd,dd,dd,dd,dd,dd,dd
275,hij,dd,dd,dd,dd,dd,dd,dd,dd,dd,dd
</code></pre>

<p>And this is what my query currently looks like:</p>

<pre><code>BULK INSERT DB_NAME.dbo.Users
    FROM 'C:\data.csv'
    WITH
    (
        FIRSTROW = 2,
        FIELDTERMINATOR = ',',
        ROWTERMINATOR = '\n'
    )
</code></pre>

<p>When I execute this query it returns 1 row affected. I checked the entry in the table and noticed that the data in the file is inserted in the table as a single row.</p>

<p>What could be causing this? What I am trying to accomplish is insert those rows in individual rows in the table. See (long)image below
<a href="https://i.stack.imgur.com/GquFc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GquFc.png" alt="enter image description here"></a></p>

<p>The first column is actually an IDENTITY column so in the file I just specified a integer even though it will be overwritten by the auto generated ID as I am not sure how to tell the query to start inserting from the second field yet.</p>

<p>There are more columns created in the actual table than specified in the file as not everything needs to be filled. Could that be causing it?</p>