DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Working with TIMESTAMP fields in Excel

671550Nov 20 2008 — edited Dec 1 2008

Please forgive me if this is a really stupid question.

I have an Oracle 10g dtabase that i am trying to connect to via ODBC in Excel.

I can get data from tables into MS Query untill i try and insert a TIMESTAMP field when all fails. The TIMESTAMP field ahave a time zone on them.

Can anyone point me in the direction of an ODBC driver which works in this situation, i have tried the standard MS driver and also the ODBC driver supplied by ORACLE.

Thanks in advance for any help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 29 2008

Added on Nov 20 2008

#odbc, #windows, #windows-and-net

3 comments

3,837 views