I'm not sure if I am posting this in the proper place. If I am not then I appologise.

I have created a spreadsheet that calls an Oracle database that I can only acces through a remote desktop connection.

When the sheet is saved on on that remote machine it calls my database and pulls in all the information I want.

The problem is, however, that not everyone has access to that terminal server.


Is it possible to have excel access and oracle database that is located on a remote server (of which I have the IP adress for) and then make its calls to Oracle?