New DB Query problem

  • Thread starter D.P. Roberts [MCSE,MCSD,MCDBA]
  • Start date
D

D.P. Roberts [MCSE,MCSD,MCDBA]

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

CLR

Probably because the rights to those other Databases are assigned by
username from the MIS dept.

Vaya con Dios,
Chuck, CABGx3
 
K

Ken Piper

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