The text of this article is not in this database — only its details are. The old site it was published on is gone, but the Internet Archive kept a copy: Format files in SQL Server
4 Comments
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment.

Kumaresh RajalingamPosted Feb 19, 2016, 8:02 PM
good one
Kumaresh RajalingamPosted Feb 19, 2016, 8:02 PM
Nice explanation
Sr KarthigaPosted Feb 19, 2016, 5:50 AM
Nice Explanation
Padmaraj ThanepatilPosted Mar 13, 2015, 6:52 AM
Can i pass FieldTerminator and RowTerminator instead of FileFormat path in C# to select bulk data from file ex: select * from OPENROWSET(BULK 'C:/Users/Administrator/Desktop/Data4.txt', FieldTerminator = ';', RowTerminator = '\n') tmpTbl