you can use ADO instead of DAO...
also you can define so called DSN-less connection strings.

see
http://www.able-consulting.com/ADO_Conn.htm
http://www.erlandsendata.no/english/...php?t=envbadac

all these connectstrings can be used directly
in excel queries..

it can be done... but you'll spend some time studying.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"PO" <po wrote:

Hi

I'm using VBA in Excel 2000 to generate reports. Each report accesses
data in various databases (currently 4 different DB) using ODBC
datasources. At least 50 persons at my company use the reports. On
each PC-client I have set up the ODBC datasources.

There are two problems:
1. Each time I make an excel-report which needs to access a new
database, all of the client machines have to be updated with new
datasources. Or each time I get a new user his or her client machine
needs to have the ODBC sources set up.

2. When accessing Oracle databases each client also needs to have
Oracle Client installed.

My questions:
1. Is it possible to use a ODBC datasource located on a server to
access the data, that is, can I in VBA code tell Excel to look for the
data source on a server?

2. and, if so, do the clients still need Oracle Client or can all the
clients use a server version?

Regards
PO