Toad World® Forums

SQL Server 2014: Creating new table from file and row counts not matching with file and Object explorer window

I am uploading a 3.2 million row file with two columns. I first create the table I want the data to go into and set the columns to be NVARCHAR(Max) and then start the import.

The system reads all rows and from the log shows that all rows were loaded correctly. I do not get errors during upload and the system does not kick any rows out.

However when I look at the Table on the system is has ~700K rows only versus the full 3.2M rows?

I am new to this so maybe i am missing something obvious but if someone can help that would be great.