How to write a C#.NET program to read excel and put the excel content in different tables?

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.
LVL 16
Easwaran ParamasivamAsked:
Who is Participating?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.