Anyone know an easy way to get from a dataset into an ADOX catalog? or from a datatable to an ADOX table?
Printable View
Anyone know an easy way to get from a dataset into an ADOX catalog? or from a datatable to an ADOX table?
The Fill method of the OleDataAdapter is overloaded to fill an ADO recordset from a DataTable. You can look into that.
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.