Hi,

I am looking to import data from excel.
Problem is that the excel can have N number of sheets and i won't know the name of the sheet.

So every time i import the data i need to dynamically create a table with that of the name of the sheet and import data from each sheet to the corresponding table.

any solutions please.

Thanks in advance.

I can't think of any way to do this. I know this is not what you wanted to see. :D

Since you posted in the DTS forum, I'm figuring you want to have this process automatically scheduled. The only solution I can come up with is to have all of the information from the worksheets in Excel copy to another worksheet and then copy that to your SQL table.

I'm going to see if I can get an example for you - its been awhile since I have done this.