Showing posts with label Bulk. Show all posts
Showing posts with label Bulk. Show all posts

Sunday, 28 August 2011

Insert Into Sql Table from Formatted Text File


use DBName
BULK INSERT  dbo.Table_1 FROM 'c:\textFileName.txt' 
WITH (      


      FIELDTERMINATOR = '\t', --Tab
      ROWTERMINATOR = 'q'      --Char 'q'
);