Fast Import to SQL Through VB.net(2005)

Question

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(2005) With 1000 Rows per seconds Is that Possible through VB.net

Please help me... Thanx in Advance

Answer 1

You'll want to use the sqlbulkcopy class.

Answer 2

It would help if you tell us what kind of SQL table is that.

In SQL Server you use BULK INSERT. If you must use Vb.Net code, the functionality is exposed in .Net via the SqlBulkCopy class. A more sensible approach is to use SSIS.