I wonder if anyone has solved this problem already.
I have a fully populated datatable (ado.net datatable) containing about 3000 rows of data with 53 fields.
I want to copy the contents of the data table into an access database table ready prepared and empty which has the identical structure in terms of fields. Although I could loop through the data table row by row and insert each row using a command insert this takes ages (several minutes). Also I dont want to use sql server, bulk copy because I want to keep all logic in vb.net program.
Is there anyway of doing this without a loop. Several days Googling has been fruitless.