Re: Excel sql.request & Oracle
From: Ranga Chakravarthi <ranga_at_cfl.rr.com>
Date: Sat, 03 Nov 2001 20:56:54 GMT
Message-ID: <qSYE7.7520$y%2.2383007_at_typhoon.tampabay.rr.com>
Date: Sat, 03 Nov 2001 20:56:54 GMT
Message-ID: <qSYE7.7520$y%2.2383007_at_typhoon.tampabay.rr.com>
Neil,
From Excel Help :
For Oracle you have to use the connect string like this: DNS=My Oracle Data Source;DBQ=MYSERVER;UID=JohnS;PWD=Sesame
If SQL.REQUEST is unable to gain access to the data source using
connection_string,
it returns the #N/A error value
HTH,
Ranga
"funkcity" <neil_at_funkcity.demon.co.uk> wrote in message
news:1004649862.657.0.nnrp-14.9e98151b_at_news.demon.co.uk...
Does anyone have an idiots guide to using the Excel 97 command sql.request
getting data from an Oracle database. I think i've set up my datasource
correctly but Excel help example is for SQL server, and i just keep getting
#N/A returned indicating there's a problem
Cheers
Neil Received on Sat Nov 03 2001 - 21:56:54 CET