SQL Server Performance Forum – Threads Archive

excel load

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

Dinesh, that link does not work
Madhivanan Failing to plan is Planning to fail

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

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q321686

Thanks Argyle
Madhivanan Failing to plan is Planning to fail

]]>