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 |
|
abarsami
Yak Posting Veteran
68 Posts |
 Posted - 2001-08-15 : 13:42:29
|
| I have this row in a text file called Me.txtAAAA,01/01/1997,7,"XXXX","LLLL",5,5,3,618My command:I want to be able to do this with both fieldterminators. BULK INSERT TableX FROM 'c:\Me.txt' WITH (FIELDTERMINATOR = '","')BULK INSERT TableX FROM 'c:\Me.txt' WITH (FIELDTERMINATOR = ',')How can I combine the two, to make one bulk insert statement.Thanks |
|
|
|
|
|
Bulk Insert Help - code posted