Loading

how to use bulk insert

snowal raj

12y1.2k

how to use bulk insert query in sql server

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhabani Prasad12y ago
u can follow below two links i t will help u 1-http://www.codeproject.com/Articles/354094/Bulk-Insert-in-NET-applications-Part 2-http://visualstudiomagazine.com/articles/2013/03/01/effective-use-of-sql-bulk-insert.aspx
0
Anupam Singh12y ago
Hi snowal,

We use bulk insert when we need to insert data for external sources like csv or text files..

here is how :

how to use select :

SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Text;Database=C:\;HDR=NO',
'SELECT * FROM test.csv')
GO

you can also insert this in sql table using :

select * into
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Text;Database=C:\;HDR=NO',
'SELECT * FROM test.csv')
GO

Hope it helps.
0