Bulk export from SQL Server Express to MS Access (disconnected DataSet ?)
Posted on 2008-10-21
In a Windows Forms C# application I need to save programmatically a bunch of tables (selected fields) from SQL Server to Access. With a full version SQL I'd use a DTS (2000) or SS Integration but Express Edition lacks export functionality.
I'd like to save data to the DataTable (no problem) and then import it to Access. I am not sure how to set up a DataAdapter for Access to use a table already filled with SQL adapter.
I can create 2 DataTables: one really filled from SQL and another filled from Access and emptied, then transfer data from the 1st to 2nd and Update Access adapter, but this seems like a clumsy solution.
Advice is much appreciated.