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'
);

No comments:

Post a Comment