Please help.. Here is what I am trying to accomplish. I have an application that fills a datagrid based on event calls from the users ( i.e user presses button, application fills empty datagrid with data from specific sql query). My next task is to take the data in that datagrid and copy it out to a MDB file for portability (user can take that MDB file back to office and extract data at will). The final step will be to take a set of SQL tables and copy them all out at once to the MDB. I have an empty MDB in my project and an empty dataset created for it.
When my messagebox pops below I can see the table count has increased, but when I open the MDB the new table is not there??
'Early on I have code that fills the datagrid from a shared SQL Class.
'the datatable that is created is a new datatable named Me.dt
'The empty MDB dataset is me.StoreExportDataSet
Private Sub btnFillMDB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFillMDB.Click
For Each tbl As DataTable In Me.dt.DataSet.Tables()
MsgBox("TABLE COUNT: " & Me.XStoreExportDataSet.Tables.Count.ToString)