Thank you Rob

I will just add one aspect.

"I have been repeatedly advised not to have SQL Server run Office automation"

You don't need to do that.

With Remote OLE DB you can have SQL Server and Office automation on separeted

machines. In fact the client can run Excel with VBA etc to fetch data from SQL Server or

transmit data to SQL Server.

/Gosta