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??