Question Fast Import to SQL

[max_yogesh2002]

Dear Friends,
I have text file which contain the 15000000 Rows with the Comma delimiters..i want to import that file to SQL Table Through VB.net With 1000 Rows per seconds
Is that Possible through VB.net.


Please help me...
Thanx in Advance

 

[MattP]

Have a look at SqlBulkCopy. In the example below the author did 1,000,000 rows in about 17 seconds.

.NET – Fastest Way to Load Text File To SQL – SqlBulkCopy - stevienova.com