Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems Using MS Oracle ODBC with Excel
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems Using MS Oracle ODBC with Excel
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 -----Original Message----- 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? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems Using MS Oracle ODBC with Excel
I have used Oracle8i over ODBC with Querytables. I don't think Excel is the
problem. -- Rob van Gelder - http://www.vangelder.co.nz/excel "news.aristotle.net" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems Using MS Oracle ODBC with Excel
On Fri, 2 Apr 2004 09:06:27 +1200, "Rob van Gelder" wrote:
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Oracle ODBC Driver Errors | Excel Discussion (Misc queries) | |||
Excel VBA against Oracle | Excel Discussion (Misc queries) | |||
link ODBC connection to an Oracle database | Excel Discussion (Misc queries) | |||
ODBC data insert to Oracle | New Users to Excel | |||
Oracle odbc | Excel Discussion (Misc queries) |