CSV file created by another program is giving me the following data:
SIMULATION Period Product OUTPUT_NEP
0 2013Q2 USSIC_Aviation 10,191,468
0 2013Q2 Avemco_Aviation 7,724,131
I'm trying to bulk insert this into SQL but the "OUTPUT_NEP" column is obviously going to give me errors because of the commas in the numbers. When I open the file as text, the OUTPUT_NEP column is in double quotes as well so it shows up as "10,191,468". Right now, that column in SQL is "float" format and I would like to get rid of the commas and quotes altogether so I don't get an error with the datatype. What's the best way to do this? Create a format file? If so, what's a simple example on doing this? I don't usually use format files.
Any help will be appreciated!