Hi,

I want to build an Excel macro to fetch and process some data from our corporate database.
That is an Oracle database, however, not the MSSQL that is covered in the book I have on Excel 2013.


Thus, I don't yet have a clear idea of how to do it.
Can anybody help me there?

Thanks a lot!

Best regards,

Officer_Bierschnitt

Do you have the Oracle client tools installed? If not, you can't do it.

I think I have - but never mind. I don't think I can do it in this way since the IT_guys protect their server like a hen it's eggs, and any connection from any reporting_tool other than Crystal (which is within the IT domain and hosted right on the server) is prohibited ;-)

The only way I can thus think of is with another tool, QlikView, because a colleague can do it, only because he can work right on the server - which is probably prohibited too as a matter of fact, but it has been so for a long while and without that, many things would not work, so no one seems to care ...

Regard this thread closed. Thanks for helping, but I don't think this will be getting us anywhere. Better use our energy for something more constructive ...

Best regards,

Officer_Bierschnitt