Written by:R Teachout
5/4/2007 10:08 AM

Sample Bulk Insert Command from a Text File into MSSQL

bulk

insert [DBName].[dbo].[Table] from 'd:\textfile.csv' with (DATAFILETYPE = 'char',FIELDTERMINATOR = ';',ROWTERMINATOR = '\n')

TrackbackPrint

Location: BlogsRamblings, Scriptlets, and more!MSSQL Scriptlets

Your name:
Title:
Comment:
Security Code Enter the code shown above in the box below
Add Comment   Cancel