Jump to content

ODBC with VS C++ 6 Problem

- - - - -

  • Please log in to reply
No replies to this topic

#1
Guest_MarkWasik_*

Guest_MarkWasik_*
  • Guests
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?




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users