Saving contents of datatable to Access table without writing SQL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

eric.goforth@gmail.com - 30 Jan 2006 17:49 GMT

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

Reply to this Message

Cor Ligthert [MVP] - 31 Jan 2006 06:20 GMT

> Hello,
>
[quoted text clipped - 4 lines]
>
> I'm using VB.NET 1.1.

A pity, the answer is No.

Cor

Reply to this Message

Jesús López - 31 Jan 2006 11:32 GMT

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

> Hello,
>
[quoted text clipped - 7 lines]
> Thanks,
> Eric

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...