what is the best way to load an excel file which contains multiple worksheets? we are currently using a custom sp which loops through the sheets, but the process is too long. any ideas? thanks ryan
See if this helps you. But you need to give sheet name http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=8440 Madhivanan Failing to plan is Planning to fail
not only DTS, There are many ways of doing this http://support.microsoft.com/default.aspx?scid=kb;en-us;Q321686#4bp as madhivan said , in all the methods you have to give the name of the worksheets
Otherwise you can cut & paste the linkhttp://support.microsoft.com/default.aspx?scid=kb en-us Q321686#4bp on a browser. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
No Still it doesnot work I think some characters are missing between kb and en-us(I am not sure) Madhivanan Failing to plan is Planning to fail
