I am trying to retrieve data from MS Excel using ODBC and SQL. Everything works good except for date/time fields. I am seeing in the excel file a time fields like the following:
00:49:30
00:50:00
00:50:30
when I read them in to a timestamp field I get the following:
00:49:30
00:49:59
00:50:29
I appears I am losing some precision thru Excel or the ODBC driver. Does anyone have any experiance with this that can help?
ODBC with VS C++ 6 Problem
Started by
Guest_MarkWasik_*
, Apr 10 2007 11:31 AM
No replies to this topic
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users


Sign In
Create Account

Guest_MarkWasik_*
Back to top









