export dataset to accessdb

[ninjaimp]

Hi

I have a small program that imports data from a txt file and then splits it into columns in a dataset.

What i want to do now is export that dataset to an access table so that i can start running reports form the data. Is there an easy to export it?

many thanks

 

[Stonkie]

If you fill the dataset by creating new rows in code and adding them to the dataset, then you should create a typed dataset that's already connected to your Access database, add the stuff in the dataset using the method you currently use and just update your dataset to the database using the table adapters...

That will generate all the INSERT SQL statements you will need.

 

[cjard]

for more info see the DW2 link in my signature.. you dont so much "export to access" as "connect to a jet database and upload data into it"