Get external data using UNC path

R

R.Douthwaite

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

Ron Coderre

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

R.Douthwaite

Thanks Ron, that pretty much does what I need.


-
R.Douthwaite.



Ron Coderre said:
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 said:
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
 
P

pkeegs

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

Ron Coderre

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=UNC+file+path+instructions

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

XL2003, WinXP


pkeegs said:
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 said:
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 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top