 |
 | 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 / New Users / April 2004New DB Query problem
In Excel 2002, when I go to Data-Import External Data-New Database Query, I get a "Choose Data Source" window that displays many items including Oracle, dBase Files, Excel Files, and MS Access Database. However, when another user logs onto the same PC and tries the same process they don't see any of those files listed. Instead, they only see Oracle listed. Does anyone know why this might be happening? Thanks! Probably because the rights to those other Databases are assigned by username from the MIS dept. Vaya con Dios, Chuck, CABGx3 > In Excel 2002, when I go to Data-Import External Data-New Database Query, I > get a "Choose Data Source" window that displays many items including Oracle, [quoted text clipped - 5 lines] > > Thanks! Actually, it defaults to your User Data sources (My Data Sources, in XP/2k3), which are blocked off by Profile (you have a different profile from the other users). You can either create and save a File Data source, or possibly setup a System Data source. Open up ODBC Administrator in the Administrative tools for more information. I hope this helps.  SignatureKen Piper MCP - SQL Server > In Excel 2002, when I go to Data-Import External Data-New Database Query, I > get a "Choose Data Source" window that displays many items including Oracle, [quoted text clipped - 5 lines] > > 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.