Dataset table to ADOX table

[Shurijo]

Anyone know an easy way to get from a dataset into an ADOX catalog? or from a datatable to an ADOX table?

[DevGrp]

The Fill method of the OleDataAdapter is overloaded to fill an ADO recordset from a DataTable. You can look into that.

[Shurijo]

Thanks. I looked into that, but I couldn't figure it out.

Basically, I have a dataset with multiple tables that I want to dump to a new access file (create access & tables and dump rs).

I can create the access db using ADOX.Catalog.Create() and I seen how to make the table and each column. But I was wondering how I could just dump an entire dataset into access and maintain the fields and records and table names, etc.