Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BrianS123
Starting Member
1 Post |
 Posted - 2008-10-29 : 09:57:43
|
| Hi folks. My first post here, so be gentle.Using Sql Server 2005, I'm trying to Bulk Insert a CSV file which MAY have quoted delimeters (if the field has a comma in it). eg:col1 text, col2 text, col3 textcol1 text, col2 text, col3 textcol1 text, "col2 text, including comma", col3 textcol1 text, col2 text, col3 text I've not sure how to handle the 'optional' double quotes when using a format file. Any help would be appreciated. |
|
|
|
|
|
Bulk Insert problem