How to use bulk insert in sql server?

Hi Ramesh,
see the below link for more information
http://www.codeproject.com/KB/database/SqlBulkCopy.aspx

Hi

Read following Article
http://www.dotnetcurry.com/ShowArticle.aspx?ID=323&AspxAutoDetectCookieSupport=1

show here good example
http://www.sqlnetframework.com/DataAccessBlog/post/2008/11/07/Bulk-insert-in-SQL-Server-2005-using-ADONET-and-XML.aspx
http://aspalliance.com/1676

Please Check my answer if you help....
Thank You...

Lalit.

Hi Ramesh,

You can do it uin sqlserver.Just create a procedure and pass the paath of the csv file nad the procedure will be like this

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[ADMIN_UPLOAD] 'D:\Test.xls'  (
@FILENAME AS VARCHAR(200)
)
AS 

BEGIN 

CREATE TABLE #tempTable (

CustomerName varchar(300),
OrderID  varchar(300) )


BULK INSERT OrdersBulk 
FROM 'D:\Tes.xls'
WITH 
( 
    FIELDTERMINATOR = ',', //specify the FIELDTERMINATOR 
    ROWTERMINATOR = '\n' //specify the ROWTERMINATOR 

)


insert into OrdersBulk(CustomerName) select CustomerName from #tempTable

insert into OrdersBulk(OrderID) select OrderID from #tempTable

end