servers - PLEASE HELP!

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.

server to SQL-Server Question

I've been trying to work with Linked Servers for the first time, with
mixed success. My problem right now is in trying to write a View using
a linked server. The linked server is another SQL-Server, and it was
set up using the 'Enterprise Manager' interface. When the server was
created, the name was given as the full server address -
name.pyr.ec.gc.ca.

When I try and use this name in a new view, I enter the name in the
query as [name.pyr.ec.gc.ca].database.dbo.table. SQL-Server rewrites
this name as name.[pyr.ec.gc.ca.database].dbo.table table_1

I'm sure this is me not understanding something about using linked
servers, but it seems strange to me none the less. Is there a way for
me to create the linked server using sp_addlinkedserver, which would
not require the full server address as the linked server name? Or is my
view syntax not correct? Or can I just not create the query as a view?

I've looked around the new groups, but have no answers yet. Any help
would be much appreciated.

Timnever mind....finally found a single entry in BOL that explained it.