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-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

Thanks Ron, that pretty much does what I need.


-
R.Douthwaite.



"Ron Coderre" wrote:

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

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 "UNC paths"? Where can I get simple instructions on setting
up UNC paths?

Regards

"Ron Coderre" wrote:

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

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:
http://www.google.com/search?hl=en&q...h+instructions

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

XL2003, WinXP


"pkeegs" wrote:

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 "UNC paths"? Where can I get simple instructions on setting
up UNC paths?

Regards

"Ron Coderre" wrote:

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