ACC2000: Import/Export Accepts Only 24-Hour Time Format (209809)
The information in this article applies to:
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).
| Modification Type: | Major | Last Reviewed: | 6/24/2004 |
|---|
| Keywords: | kbinterop kbprb KB209809 |
|---|
|