software

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

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-Proquot;R.Douthwaitequot; wrote:

gt; Hello all,
gt;
gt; Hoping someone can help me here.
gt;
gt; I have an excel file that pulls in external data to two of the worksheets
gt; from Access database queries located on a server.
gt;
gt; I have no problem setting this up if I use mapped drive letters but...
gt;
gt; My question is, is there any way to get external data using a UNC path
gt; rather than a drive letter path?
gt;
gt; The file can be opened from the access database front end but the
gt; possibility exists that not every user will have the network folder mapped to
gt; the same drive, hence the desire to use a UNC path.
gt;
gt; Any help would be much appreciated
gt;
gt; Thanks in advance
gt;
gt; --
gt; R.Douthwaite.
gt; Information Coordinator
gt; www.swift-research.co.uk


Thanks Ron, that pretty much does what I need.-
R.Douthwaite.
quot;Ron Coderrequot; wrote:

gt; Unless I have a very compelling reason not to, I prefer to use UNC paths to
gt; data sources. If you've already created the Excel query, you might try this:
gt;
gt; Edit the query
gt; Click the [SQL] button
gt; Edit the mapped drive path to be the UNC path.
gt;
gt; Example:
gt; Change this:
gt; SELECT * FROM K:\MyDatabase.mdb
gt;
gt; to something like this:
gt; SELECT * FROM \\NetworkServer\DB_Folder\MyDatabase.mdb
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;R.Douthwaitequot; wrote:
gt;
gt; gt; Hello all,
gt; gt;
gt; gt; Hoping someone can help me here.
gt; gt;
gt; gt; I have an excel file that pulls in external data to two of the worksheets
gt; gt; from Access database queries located on a server.
gt; gt;
gt; gt; I have no problem setting this up if I use mapped drive letters but...
gt; gt;
gt; gt; My question is, is there any way to get external data using a UNC path
gt; gt; rather than a drive letter path?
gt; gt;
gt; gt; The file can be opened from the access database front end but the
gt; gt; possibility exists that not every user will have the network folder mapped to
gt; gt; the same drive, hence the desire to use a UNC path.
gt; gt;
gt; gt; Any help would be much appreciated
gt; gt;
gt; gt; Thanks in advance
gt; gt;
gt; gt; --
gt; gt; R.Douthwaite.
gt; gt; Information Coordinator
gt; gt; www.swift-research.co.uk

I have a similar problem with an access database query. We are using a PC
server in a small office network which stores all the files. The path
required for the query in my excel file is different for the server than if I
use the file on the non-server PCs. It means I have to change the query path
every time I use the file on the server. Is the solution somehow in what you
are referring to quot;UNC pathsquot;? Where can I get simple instructions on setting
up UNC paths?

Regards

quot;Ron Coderrequot; wrote:

gt; Unless I have a very compelling reason not to, I prefer to use UNC paths to
gt; data sources. If you've already created the Excel query, you might try this:
gt;
gt; Edit the query
gt; Click the [SQL] button
gt; Edit the mapped drive path to be the UNC path.
gt;
gt; Example:
gt; Change this:
gt; SELECT * FROM K:\MyDatabase.mdb
gt;
gt; to something like this:
gt; SELECT * FROM \\NetworkServer\DB_Folder\MyDatabase.mdb
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;R.Douthwaitequot; wrote:
gt;
gt; gt; Hello all,
gt; gt;
gt; gt; Hoping someone can help me here.
gt; gt;
gt; gt; I have an excel file that pulls in external data to two of the worksheets
gt; gt; from Access database queries located on a server.
gt; gt;
gt; gt; I have no problem setting this up if I use mapped drive letters but...
gt; gt;
gt; gt; My question is, is there any way to get external data using a UNC path
gt; gt; rather than a drive letter path?
gt; gt;
gt; gt; The file can be opened from the access database front end but the
gt; gt; possibility exists that not every user will have the network folder mapped to
gt; gt; the same drive, hence the desire to use a UNC path.
gt; gt;
gt; gt; Any help would be much appreciated
gt; gt;
gt; gt; Thanks in advance
gt; gt;
gt; gt; --
gt; gt; R.Douthwaite.
gt; gt; Information Coordinator
gt; gt; www.swift-research.co.uk

If you have any IT staff in your organization, they can explain Universal
Naming Convention (UNC) usage as it pertains to your situation.

Also, see if this website helps:
www.google.com/search?hl=enamp;q...h instructions

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

XL2003, WinXPquot;pkeegsquot; wrote:

gt; I have a similar problem with an access database query. We are using a PC
gt; server in a small office network which stores all the files. The path
gt; required for the query in my excel file is different for the server than if I
gt; use the file on the non-server PCs. It means I have to change the query path
gt; every time I use the file on the server. Is the solution somehow in what you
gt; are referring to quot;UNC pathsquot;? Where can I get simple instructions on setting
gt; up UNC paths?
gt;
gt; Regards
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; Unless I have a very compelling reason not to, I prefer to use UNC paths to
gt; gt; data sources. If you've already created the Excel query, you might try this:
gt; gt;
gt; gt; Edit the query
gt; gt; Click the [SQL] button
gt; gt; Edit the mapped drive path to be the UNC path.
gt; gt;
gt; gt; Example:
gt; gt; Change this:
gt; gt; SELECT * FROM K:\MyDatabase.mdb
gt; gt;
gt; gt; to something like this:
gt; gt; SELECT * FROM \\NetworkServer\DB_Folder\MyDatabase.mdb
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;R.Douthwaitequot; wrote:
gt; gt;
gt; gt; gt; Hello all,
gt; gt; gt;
gt; gt; gt; Hoping someone can help me here.
gt; gt; gt;
gt; gt; gt; I have an excel file that pulls in external data to two of the worksheets
gt; gt; gt; from Access database queries located on a server.
gt; gt; gt;
gt; gt; gt; I have no problem setting this up if I use mapped drive letters but...
gt; gt; gt;
gt; gt; gt; My question is, is there any way to get external data using a UNC path
gt; gt; gt; rather than a drive letter path?
gt; gt; gt;
gt; gt; gt; The file can be opened from the access database front end but the
gt; gt; gt; possibility exists that not every user will have the network folder mapped to
gt; gt; gt; the same drive, hence the desire to use a UNC path.
gt; gt; gt;
gt; gt; gt; Any help would be much appreciated
gt; gt; gt;
gt; gt; gt; Thanks in advance
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; R.Douthwaite.
gt; gt; gt; Information Coordinator
gt; gt; gt; www.swift-research.co.uk