Problems Using MS Oracle ODBC with Excel

[news.aristotle.net]

I have a spreadsheet that has sql in VBA that queries data from an Oracle
v7.3 db. Numbers are pasted to the spreadsheet as alpha and sum functions
do not work. The driver version is 2.573.7713.00 and I am using W2K and
O2K. Any ideas?

 

[Raul]

You can modify the SQL query to cast the data as integer
or real.

For example:
SELECT OrderNum, CAST(OrderNum AS INT) As NewOrderNum
FROM ....
WHERE...

In the above example the query will return two columns of
data, one for OrderNum and another for NewOrderNum. You
could eliminate OrderNum and get back one column of data.

You can then use the data retrieved from NewOrderNum in
your spreadsheet.

Hope this helps,

Raul

 

[Rob van Gelder]

I have used Oracle8i over ODBC with Querytables. I don't think Excel is the
problem.

 

[Toby Erkson]

I have used Oracle8i over ODBC with Querytables. I don't think Excel is the
problem.

Ditto. Determine how the values are stored in the db.
Toby Erkson
Oregon, USA