Copy all data in DataTable to empty DB Table?

[CraigBest]

In a VB.NET 2005 app that I'm building, I've selected records I need to process from an Access DB table into a VB Data Table. Now I want to copy the contents of that data table back into a blank Access table with the same structure. Is there an was to build an Insert query to do this?

CraigHartz

 

[CraigBest]

Well I located this post from Sorwen three years ago...

http://www.tek-tips.com/viewthread.cfm?qid=1417876&page=13

If he could not find an answer, I doubt I will - Guess I'll have to do it row by row. Oh well.

CraigHartz

 

[RiverGuy]

If you need a copy of the DataTable, just use the DataTable.Copy method. Then connect that new copy to a DataAdapter which has the Insert, Update and Delete statements for the Access table.