If you use Access, one quite easy way is to use
TransferText[
^] method to save the data in a CSV file and then open it using Excel. You can use for example Interop for Access to call appropriate methods.
Another way could be to use OleDb and open a connection with OleDbConnection and do a select to appropriate table and save the result in a dataset. After that, export the dataset to Excel. There are lots of articles concerning this, for example:
-
Fast Exporting from DataSet to Excel[
^]
-
DataTable to Excel[
^]
-
Export to EXCEL from Datatable in C#.Net[
^] etc.