I've excel which contains 100 sheets. Based on the excel sheet names I would like to create the table names in a given database and put the sheet content over there..
There is one way that I could read each sheet using select * from [Sheet1$]" and so on... But this is time taken process.
Is there any simple way to automate this? If so, please do guide how to achieve this using sample application or relevant links. Thanks in advance.