I am working on a project where I want to convert all the mdb files in a folder to xls files in C# or VB.
Here user will select folder and then all the mdb files in that folder should get converted to excel files having same name.
Also mdb file can contain many no. of tables and and I want each table in mdb file must be converted to different sheet having same name as that of table.
Please help me with some piece of code.


What will you do with the non-table content like embedded SQL, stored procedures, forms, etc.?

This almost seems like it would be a better job for VBA where you would write macros to export the target tables?