Transferring data from text file

How to transfer data from a text file to SQL table, Which is the best method to do that?

Veeramma
Profile Answers by Veeramma Questions by Veeramma
May 22nd, 2008
1
2451

Showing Answers 1 - 1 of 1 Answers

sakthi.jaganathan
Profile Answers by sakthi.jaganathan

Aug 25th, 2008

By using OPENROWSET command

Example:
                   INSERT INTO dbo.ImportTest
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:ImportData.xls', 'SELECT * FROM [Sheet1$]')

We can do it in anotherway also by using BULK INSERT

Example:


                      BULK INSERT dbo.ImportTest
                      FROM 'C:ImportData.txt'
                      WITH ( FIELDTERMINATOR =',', FIRSTROW = 2 )