Save dataset

I have a dataset which is not tied to a database in any way.

It is created and populated in code.

What i need to know is,

How do I save the contents of this dataset into a table in Access?

I have tried merge but I cant seem to get it to work "i'm an idiot".

Are there any other approaches??

Have you invoked .AcceptChanges at any point along the way in creating your dataset? If not then OleDbDataAdapter.Update should push your new records into the Access database, once you have the OleDbDataAdapter correctly associated with the database file.