 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008Creating pivot table from Access database
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 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) > Hello, > [quoted text clipped - 3 lines] > I cannot find a way to map it to the network \\ drive, instead only from a > letter drive. Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.