How can I insert all records from a DataSet to an Access Table.

Thanks

As long as the rowstate is Added, then you can just call Update (provided
you have a valid insert command). You need to make sure the Rowstate is
Added. If you cna't do that, then you'll need to walk through the rows and
build a sql statement then call ExcecuteNonQuery.

http://www.knowdotnet.com/articles/datasetmerge.html
[quoted text, click to view]