<div>
Pls try this..<br />
&nbsp;<br />
<b><br />
DataAdapter.Update(DataSet<wbr />)</b><br />
<br />
Ref more at below - &nbsp;&lt;&lt;<b>Updating Data Sources with DataAdapters</b>&gt;&gt;<br />
<br />
<a href="https://msdn.microsoft.com/en-us/library/system.data.common.dataadapter.update(v=vs.110).aspx" rel="ugc">https://msdn.microsoft.com/en-us/library/system.data.common.dataadapter.update(v=vs.110).aspx</a>
</div>


Pls try this..
 

DataAdapter.Update(DataSet)

Ref more at below -  <<Updating Data Sources with DataAdapters>>

https://msdn.microsoft.com/en-us/library/system.data.common.dataadapter.update(v=vs.110).aspx [https://msdn.microsoft.com/en-us/library/system.data.common.dataadapter.update(v=vs.110).aspx]

<div>
hi Thanks, Is there a better way of doing this in .NET ?
</div>


hi Thanks, Is there a better way of doing this in .NET ?

<div>
The option you choose is a loop method row by row. It is not bulk update.
</div>


The option you choose is a loop method row by row. It is not bulk update.

<div>
<div class="content wysiwyg-content">
Hi Experts ,<br />
&nbsp; &nbsp; &nbsp;I need the following<br />
&nbsp; &nbsp; &nbsp; read a field Fld1 oracle database OraTb<br />
&nbsp; &nbsp; &nbsp; populate the field Fld1(Name can be changed to Fld2 ,if necessary) &nbsp;an Access table &nbsp;AccessTb &nbsp; values from Oracle Fld1<br />
&nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp;I can loop thru Oracle table fill into a .net Datatable &nbsp;. &nbsp; Loop thru &nbsp;the datatable and insert into Access table with ExecuteCommand<br />
&nbsp; &nbsp; &nbsp; &nbsp;But is there a more efficient way of doing this &nbsp;with VB.NET ? ( I know this is an ETL activity but I can't use it now)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; Thanks
</div>
</div>


Hi Experts ,
     I need the following
      read a field Fld1 oracle database OraTb
      populate the field Fld1(Name can be changed to Fld2 ,if necessary)  an Access table  AccessTb   values from Oracle Fld1
 
       I can loop thru Oracle table fill into a .net Datatable  .   Loop thru  the datatable and insert into Access table with ExecuteCommand
       But is there a more efficient way of doing this  with VB.NET ? ( I know this is an ETL activity but I can't use it now)
          
  Thanks

VB.NET bulk update  of a table from another table

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,