Code:
Expand|Select|Wrap|Line Numbers
- BULK INSERT Descriptions
- FROM '......\Descriptions.txt'
- WITH (FIELDTERMINATOR = '\t',
- ROWTERMINATOR ='\n')
One of the descriptions in the file goes over 2 lines (enclosed in quotes) and it's messing things up.How can I work with this?
ex:
item1 description1
item2 "description2...............
...continued description2......"
item3 description3.......
Thanks.