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 |
|
Trudye
Posting Yak Master
169 Posts |
 Posted - 2008-06-05 : 13:04:51
|
| Hi Guys, I have a question: when I use the Bulk Import command in my proc, it removes all dbl quotes except the 1st and the last dbl quote in each record. Is there a way to solve this problem BULK INSERT dbo.zGE_RCF_POS_IMPORT FROM 'C:\My_IMPORT.txt' WITH (FIELDTERMINATOR = '","')Thanx much,Trudye |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-05 : 13:10:21
|
| Use a format file to specify exactly how your data looks. It didn't remove the beginning and end double quotes, since those weren't in between fields. Field terminators are the character(s) in between fields.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
|
|
|
Bulk Insert Problem