Hello,

In ADO.NET is there anyway to save the contents of an datatable
directly to an Access table without having to loop through and generate
a SQL insert query string?  I figure there's probably a way to do it as
one chunk.

I'm using VB.NET 1.1.

Thanks,
Eric

<eric.gofo***@gmail.com> schreef in bericht
A pity, the answer is No.

Cor

If the data rows state is added, there is a pretty straightforward way to do
it:

        Dim MyTable As DataTable = GetTable()
        Dim Adapter As New OleDbDataAdapter("SELECT Field1, Field2, Field3
FROM MyTable", "connection string")
        Dim Builder As New OleDbCommandBuilder(Adapter)
        Adapter.Update(MyTable)

Regards:

Jesús Lóopez
VB MVP

<eric.gofo***@gmail.com> escribió en el mensaje
Show quoteHide quote

AD.NET 2.0: BindingSource and Parent Child relationship
DataColumn.Exression and string formatting
How do I assign a typed DataTable to its typed DataSet?
Datagrid calculated column not updating
Manipulating data on input w/ TableAdapter & Dataset.