Member Avatar for rcreation33

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.

Thanks!

  • 2 Contributors
  • 1 Reply
  • 92 Views
  • 31 Minutes Discussion Span
  • Latest Post Latest Post by thines01
Member Avatar for thines01

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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.