ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problem with MS Query in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/111755-problem-ms-query-excel.html)

Hayeso

Problem with MS Query in Excel
 
Not sure where to post this question. but here goes...

The problem that I have has to do with using Microsoft Query (launched in MS
Excel)with a "Microsoft ODBC for ORACLE" connection.
Whereas I can connect to this using SQLPLUS, I cannot connect to it from
Excel...Data ...Import Data....New Database Query.

I get an error message box which contains a yellow Exclamation mark icon as
well as another Exclamation mark as text. No Other text is in the message box.

This has happened on several computers in my Org and can generally be fixed
by reinstalling ORACLE client.

I would dearly like to know what I need to set in ORACLE to avoid having to
reinstall it.


All times are GMT +1. The time now is 04:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com