Can anyone tell me if they've ever been able to
dynamically create and populate an Excel spreadsheet using
a UNC?
So far, we have only been able to create the spreadsheet,
not populate it or even query it, using a UNC. We have
had no problems using a local drive letter to create,
populate and select from a dynamically-created spreadsheet.
Any help is greatly appreciated!
Cheers,
-mWhat kind of error do you get when you try the UNC?
What method are you using to try to populate it (linked server query from
SQL, DTS, pull from Excel, etc.)? The exact code would be useful.
Make sure that you have sufficient permissions to the Excel file based on
how you execute it. For instance, a job will use either the SQL Agent
startup account permissions or the proxy account depending on job ownership.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment