Glad to hear from you Bennie. Hope everything will be fine with you.

I am eagerly waiting for the next article.

Do we still have any hope for the rest of the articles in this series? Can some other expert jump in and complete puzzle?

I need to get information on this...

Thanks. I will try that approach.

Yes, it works that way on both prod and dev servers.

And I just tested...

RBarryYoung (1/5/2009)

---

Well, I've never seen it for OPENROWSET, but it sounds like you are being bitten by the "Two-Hop Rule". This thread has a good explanation of it for...

The Excel file is not open by any other program.

I can browse to the network folder and click on the file name to open it in Excel using Windows explorer.

I have no problem in using SQL Management Studio and...