Microsoft KB Archive/209809

= ACC2000: Import/Export Accepts Only 24-Hour Time Format =

Article ID: 209809

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q209809



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
When you import or export time values, Microsoft Access only works with 24-hour time values. For example, if you export a value such as 1:00 P.M. to an ASCII text file, the value will be exported in the 24-hour format as 13:00.



RESOLUTION
To work around this behavior when you export data, please see the following article in the Microsoft Knowledge Base:

209268 Exporting Date Fields to Text Includes Time Format

To work around this behavior when you import data, import the Date/Time data into a Text field. Then you can use an update query or Visual Basic code to manipulate the values into the correct format for your Date/Time field.



MORE INFORMATION
If you try importing a time value such as 1:00 P.M. into an existing Date/Time field, the record is not imported and you receive an Import Errors table that shows a "Type Conversion Failure" for the value. To import a time value such as 1:00 P.M. into a Date/Time field, the value must be in the 24-hour format (in this case, 13:00).

Additional query words: military clock prb

Keywords: kbinterop kbprb KB209809

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.