hI

Yep, you can call bcp or use the bulk insert command, check BOL for a good
coverage.
Otherwise, how about writing up a small COM in VB and using the FSO (file
system objects),
doing a call to it via the oa routines, depending on the complexity of
course.

Look at DTS as well, see www.sqldts.com for guidance.

Cheers

Ck

-----Original Message-----
From: Shibu MB [mailto:[Email Address Removed] Saturday, 23 November 2002 3:47 PM
To: LazyDBA.com Discussion
Subject: Flat file reading ......


Hi all....

Can sqlserver read and write from flat file using t-sql . I was
just checking whether there is any other options in sqlserver to read and
write to a flat file than the BCP utility..... Can i schedule to read
and
write using BCP utility .IF yes how is that done .


Thanks
Shibu

MS Sql Server LazyDBA home page