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

ID: Q209809

The information in this article applies to:
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:

Q209268 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 kbdta IntpOff IsmGnrl 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: May 13, 1999