Oracle interval columns
 
Using the ORAOLEDB provider/driver, SQL*XL can work fine with columns in Oracle of the data type interval. OO4O can also deal with interval data. A small code change was needed in SQL*XL to allow querying interval data through the OO4O driver. Unfortunately the OO4O driver cannot be used to alter values using the multiple rows update feature.
 
The recommendation is therefore that you use the ORAOLEDB provider: the Oracle OLE DB provider, when working with interval data. SQL*XL can query and update information using this driver.
 
See also:
Using Oracle interval columns  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1232373646/0
The Oracle interval data type  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1232369558/0