I am using sql-server (2014) to import data from a .csv file to a sql-server table. I am using bcp and a format file . Everything works fine, except that all my data including the columns have double quotes. I do not need the double quotes. Here is how the data in the .csv file looks:
![85750-csv.jpg][1]
Here is how my SQL statement looks like:
![85850-statement.jpg][2]
These are the results:
![85858-results.jpg][3]
So besides getting the headers in the first row, I also see everything is in double quotes. I want to eliminate the double quotes while importing and exclude the headers as part of my rows.
Here is the format file I am using:
![85873-format.jpg][4]
Please provide any guidance. Even a different approach. Ultimately, I want to be able to execute a store procedure so using a wizard is not an option as it involves manual intervention.
[1]: /answers/storage/attachments/85750-csv.jpg
[2]: /answers/storage/attachments/85850-statement.jpg
[3]: /answers/storage/attachments/85858-results.jpg
[4]: /answers/storage/attachments/85873-format.jpg




