CODEWITHSUNDEEP
vb.net
John
John

Reputation: 721

Fast Import to SQL Through VB.net(2005)

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

Upvotes: 1

Views: 248

Answers (2)

Remus Rusanu
Remus Rusanu

Reputation: 294297

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.

Upvotes: 1

Paul van Brenk
Paul van Brenk

Reputation: 7549

You'll want to use the sqlbulkcopy class.

Upvotes: 1

Related Questions