Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Invalid datetime format with odbc connection (VBA, Excel)

555070Jan 8 2007 — edited Jan 9 2007

Hello!

I try to use QueryTable to extract data from the oracle-db.

Source:
sConn = "ODBC;DSN=" + odbc_dns + ";"
Set oQt = tabelle.QueryTables.Add(Connection:=sConn, Destination:=tabelle.Range("a5"), sql:=sSql)

oQt.Refresh

As result I get this error message:
"[Oracle][ODBC] Invalid datetime format"

Is there any setting I need to do?

regards
Pietro

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 6 2007

Added on Jan 8 2007

#general-database-discussions

5 comments

3,564 views