Saving a data table to a MS Access database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi -

I've a data table that I want to save to an external Access database.

I'm interested in sample code that would perform this save.

Thanks, Mark
(VB.NET, .Net framework 1.0)
 
Mark,

From where did you get your datatable?

You cannot create from a hand made datatable a database. This is maybe an
option for a next version from Visual Studio Net.

Cor
 
Cor -

The program populates a datatable from a connection to an Excel workbook.

It's in a loop, with each iteration the workbook is opened, calculates the
result, and the result is saved in a datatable residing in the VB program.

When the loop is done I want to save the datatable to an External Access
Database for use in other apps.

Thanks,
Mark
 
Why don't you create your DataBase with the appropriate blank table
containing all the fields you want. You can then fill a dataset with the
blank datatable from the database, update your dataset then when finished,
update the datatable in the database.
 
Back
Top