We have a Master Excel sheet which the vendors send us with the required information. Not all vendors have MS Access. So, it is upto us to import the data from Excel into Access using the wizard. Unfortunately, for now, our system can accept just .mdb files for processing.
We are trying to automate the process wherein, there would be a button which would say "Convert to MDB". So, that should generate a .MDB (database) with the tables as the sheets available in Excel sheet.
If the Excel workbook contains 3 sheets (sheet1, sheet2, sheet3), then, the AccessDB should have three tables (sheet1, sheet2, sheet3) along with the data.
For simplicity, we can assume all the data to be imported is for "Text" format.
I am wondering if there is a working solution for the same.
Any help is appreciated.
We are trying to automate the process wherein, there would be a button which would say "Convert to MDB". So, that should generate a .MDB (database) with the tables as the sheets available in Excel sheet.
If the Excel workbook contains 3 sheets (sheet1, sheet2, sheet3), then, the AccessDB should have three tables (sheet1, sheet2, sheet3) along with the data.
For simplicity, we can assume all the data to be imported is for "Text" format.
I am wondering if there is a working solution for the same.
Any help is appreciated.
