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

ID: Q209809

The information in this article applies to:

Microsoft Access 2000

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