"PO" <po wrote ...

I use ADO.
My biggest problem are the number of client machines involved. Typically
they just have Office Professional installed (no MDAC or Oracle Client).

Preferably I would like to install:

1. MDAC
2. Oracle Client (I also have a server version)
3. ODBC datasource

on a server so I don't have to install the drivers on all the client
machines. The excel-reports I send to the users "know" which server to
contact to access the data through the servers datasources.

I don't know if this is possible and perhaps there are other solutions(?).

I want to use Excel as a reporting tool but I don't want to have to update
all client machines each time I get a new user. Perhaps there is a way to
make use of our intranet somehow to get the data to the client machine?

If you want the client machines to use ADO to connect to the
databases, they need to have MDAC and appropriate drivers/providers
locally (I think there was a recent post that suggested odbc may be
used for machines without the Oracle client). Alternatives include
'pushing' data to Excel clients using server side processes or
'pulling' data into Excel using other technologies e.g. Office SOAP
toolkit using a web service (however, a client without MDAC is
unlikely to be running OfficeXP or above <g).

Jamie.

--