Re: Oracle PO8, MS Excel, Parameterised queries & dates

From: Gerrit-Jan Linker <gjlinker_at_litconsulting.freeserve.co.uk>
Date: Sat, 14 Aug 1999 12:44:02 +0100
Message-ID: <7p3kqh$4aa$1@news7.svr.pol.co.uk>

Why not forget about all the ODBC hassles? You may use my Oraxcel LITE utility to connect to Oracle from Excel. It's fully free and allows you to send queries to the database and receive the results in your spreadsheet.

Oraxcel may be found and downloaded from http://members.aol.com/gjlinker

Oraxcel can execute parametrised queries. Examples are on the site as animated gifs and lotus screencam movies. Also much info is in the FAQ.txt docuement.

Regards, Gerrit-Jan Linker

Philip Thatcher wrote in message <7omqgo$6vu$1_at_supernews.com>...
>
>Hello All,
>
>I'm trying to use MS Query to fill in some Excel cells from Personal Oracle
>8 DB.
>Currently I'm using Microsoft's ODBC driver for Oracle.
>
>The query I'm using is roughly "SELECT * FROM table WHERE table.date
BETWEEN
>? AND ?"
>
>When Excel prompts me for the parameter I enter "08-Feb-1999". But I get
>an error back immediately saying "[Microsoft][ODBC driver for
Oracle]Invalid
>scale value".
>
>Any ideas?
>
>All help gratefully received.
>
>
>PhilipT.
>Using Excel97 SR-2, PO8, on Windows NT 4.0 SP5
>
>
>
>
>
Received on Sat Aug 14 1999 - 06:44:02 CDT