Creating pivot table from Access database

C

Cam

Hello,

Is there a way to not select a drive letter when creating pivot table in
Excel directly from an Access database? On the select database popup screen,
I cannot find a way to map it to the network \\ drive, instead only from a
letter drive. Thanks
 
R

Ron Coderre

I believe so....

In the "Select Database" dialog window....
Just type in the UNC (or part of it) in the Database Name box
and let the window help.

Type as much of the path as you know
Example:
\\ServerName\Folder1\
Click [OK]

The window will display folders under Folder1 so you can navigate to the
file.

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 

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

Similar Threads

Pivot Table with MS Access as DataSource 1
Pivot Table 2
Pivot Table - ODBC Link to Access db 2
how to drag multiple items to pivot table report at once 0
Checking/amending the external source link to an Access table 1
Finding the Access query a pivot table is based on 1
Pivot Tables 1
Exporting data to Excel pivot table from Access 3

Top