SQL Server DTSDiscussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the SQL Server DTS section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
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.
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.
Import From excel with n sheets
Linear Mode
