I am writing an application which needs to save data to a new Jet (MS Access) database. What I would like to clarify is that there is no straightforward way of simply saving an existing DataSet as an MDB file, and instead I have to:
1. Create the empty database using ADOX.
2. Manually populate the new DB with Tables and Columns.
3. Copy each DataRow from the DataSet to the new Tables.
It just seems that this is a mighty long winded way of doing things. I have a DataSet complete with Schema, why isn't there a simple way of just dumping that DataSet to disk as a Jet DB file, or is there?
Thanks,
Rod.
1. Create the empty database using ADOX.
2. Manually populate the new DB with Tables and Columns.
3. Copy each DataRow from the DataSet to the new Tables.
It just seems that this is a mighty long winded way of doing things. I have a DataSet complete with Schema, why isn't there a simple way of just dumping that DataSet to disk as a Jet DB file, or is there?
Thanks,
Rod.