Posted by rhaazy on 08/15/07 16:04

I figured out that I can just include a bulk insert statement in my
script to do this::

BULK INSERT tmpStList FROM 'c:\TxtFile2.txt' WITH (FIELDTERMINATOR =
',')

however I can't figure out how to use a tab as the field terminator as
opposed to ,

• Next in forum: Re: standard and easy way to do schema design
• Prev in forum: Re: standard and easy way to do schema design
• Thread view: Re: Create script to insert 200 rows into table

[Reply to this message]