I want to connect oracle from excel 2010.
My requirement is as below:
My machine has oracle client installed but the excel file needs to be distributed to approx 200 people.Those people does not have oracle client installed.
I want that instead of mentioning service name (which resolves through my tnsnames entry defined in my local machine), connection should use database host name(IP Address) and DB name.
I do not know how to do this.
Pls. give me step by step instruction for doing the same