Hello.

I'll be very concise.

I have a problem exporting a datatable to a MySQL Database.
The amount of data can be very large (anyway this does not matter).

How can I save the records directly, witout using a for...next loop or a while.... loop?

I've tried a lot of methods with the MySqlDataAdapter

the name of the datatable is: newtable
it already contains data

the connection to mysql is ok and active: conn
the table structure is already created in the database: tmptbl
but it has no records

.......
If Not conn.State = ConnectionState.Open Then conn.Open()

Dim dadept1 As New MySqlDataAdapter("SELECT * FROM `" & tmptbl & "`", conn)
Dim cb As New MySqlCommandBuilder(dadept1)
dadept1.Update(newtable)
......

this code obviously, doesn't work

Can anybody help me with this ?

Thank you very much.