Use the same connection details as you would use with SQL*Plus.
If you are prompted by SQL*XL that OO4O is not or incorrectly installed you have 2 options: connect using ODBC
or OLEDB with SQL*XL ADO or install OO4O.
OO4O is always shipped with Oracle licenses. Look on your Oracle Client CD or on the Personal Oracle CD.
You can download the latest version of OO4O from metalink or from technet.oracle.com
(look in the software / drivers section)
Note for Oracle 8.1.7 users:
The initial version of OO4O for this Oracle version will prevent you from using the insert feature in SQL*XL. I
recommend you to install the latest available version of OO4O.
Copyright (C) 1995-2014 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.