Data Conversion Error in SQL

I am importing a csv into SQL using the Import and Export Wizard. I get the following error. My question is how does one look at the firms field without using Excel? 1.468 million rows is too much for excel 2010 apparently. Trying to find out what is wrong with this particular column or field.

Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data 
conversion 
for column "firms" returned status value 2 and status text "The value could 
not be converted because of a potential loss of data.".
(SQL Server Import and Export Wizard)