When importing a table through ODBC link from Microsoft SQL Server into Microsoft Access, the field named LKL_DATE is converted from a format displayed in the user interface of Military Zulu time which uses a format of
ddhhhhZmmmYYYY to a strictly numerical format when viewed from the table in Microsoft Access. Below is an example. My questions are what format is the data being converted to between the SQL server and being viewed in Microsoft Access.
The second is how do I convert the field data in Microsoft Access back to a date time format. Below is an example.
Format in application GUI: 061002ZMar2011
Format when Imported into Microsoft Access Table: 1299405720
View Complete Post