:confused: Hi, i need help to get the system time format.
I have an Access 2003 database, where automatically import (through to the TransferSpreadsheet function), a Excel Spreadsheet generated by any DB2 database server.
Some fields in spreadsheet are time values formatted in 12h format time.
When the importation process run, if the system time format are set whitout suffix (am/pm), the time values set between 12:00 and 23:59 are lost. If the time format are set with suffixes, the importation process works correctly.
The most workstations in my country are set in 24h without suffix.
I need know if the system time have or not suffixes to leave run the importation process.
Can you help me to resolve this?

Thanks and regards from Argentina