I'm trying to BCP a data file into a SQL database table. The file goes in okay but all of the character fields or stings have quotes around them. Is there a way to take away the quotes?
The data file I am BCP in is a comma delimited file with quotes around all string variables but NOT around other types of variables.
Example: "CustomerName", 12.20 "Main St"
I thought I could get around this in the format file but haven't been able to figure it out.
Format file is as below
1 SQLCHAR 0 255 "," 1 CustId
2-89 same as above.
90 SQLCHAR 0 8 "\r\n" 90 UnearnedYTD
Any help would be greatly appreciated.