how to use bulk insert

Question

how to use bulk insert query in sql server

Bhabani Prasad · Answer

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

Anupam Singh · Answer

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.