Unless I have a very compelling reason not to, I prefer to use UNC paths to
data sources. If you've already created the Excel query, you might try this:

Edit the query
Click the [SQL] button
Edit the mapped drive path to be the UNC path.

Example:
Change this:
SELECT * FROM K:\MyDatabase.mdb

to something like this:
SELECT * FROM \\NetworkServer\DB_Folder\MyDatabase.mdb

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"R.Douthwaite" wrote:

Hello all,

Hoping someone can help me here.

I have an excel file that pulls in external data to two of the worksheets
from Access database queries located on a server.

I have no problem setting this up if I use mapped drive letters but...

My question is, is there any way to get external data using a UNC path
rather than a drive letter path?

The file can be opened from the access database front end but the
possibility exists that not every user will have the network folder mapped to
the same drive, hence the desire to use a UNC path.

Any help would be much appreciated

Thanks in advance

--
R.Douthwaite.
Information Coordinator
www.swift-research.co.uk