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