Re: vb.net array to SQL server table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I would take a different approach unless you don't mind waiting for 100,000
Inserts to execute. If you create a delimited file you can import the data
into your database. Most DBMS vendors have import utilities. SQL Server uses
DTS or BCP which can import delimited files in a small fraction of the time
it takes to perform INSERT operations.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"11Oppidan" <11Oppidan@xxxxxxxxxxxxxxxx> wrote in message
news:O5yvogroFHA.764@xxxxxxxxxxxxxxxxxxxxxxx
>I have generated 100k values in a vb.net array and I want to use them to
>update a field in 100k records in a sqls table that has an ID field 1-100k.
>I need the first record in the array to go in the record with id 1 etc.
>
> Does anyone have any good idea about hoe to do this nicely?
>
> thanks.
>


.

Relevant Pages

  • replace all ^p s unless followed by a date
    ... I am using word to prepare a delimited file to be imported into Excel and am ... characters and I would like to implement a more elegant solution. ... Set wdApp = CreateObject ... .Execute Replace:=wdReplaceAll ...
    (microsoft.public.word.vba.general)
  • Re: Reading .csv files containing the "-" character
    ... An alternative (for any delimited file) ... start REGEDIT clicking non yous start> execute menu ... right click on the entry> change and set 0 in place of the current ...
    (microsoft.public.dotnet.languages.vb)