Import and Modify Data in SQL Server
Posted on 2011-10-03
I have a CSV file that I am trying to import into SQL Server 2008. This file contains values that are all surrounded with quotation marks. I want to remove the quotation marks from the data as I insert the data into the database; the reason being some of the fields are integers, and therefore cannot accept quotation marks.
Is there some way I can use a SQL function such as REPLACE() to remove the quotation marks from the data with SQL before it gets inserted?