I created a small text file with some times listed, read this with Monarch. Created a Monarch table and exported the result to MS Access (Access 2000) and the Access table shows the fields as Date/Time fields displaying the time but no date.
This seems to be different to your results.
I'm using Monarch 8.01 with Windows XP Home. It may be that there are some differences in different versions so I think we should establish what you are using first so that we are looking at the same configuration as far as possible in case that is significant.
Your test was very helpful. There actually is a date stored when you perform this test but it is the correct zero date (12/20/1899). You need to format the field to always display the date.
This issue arose because I am reading off a DB2 table. DB2 has three data types: Time, Date, and Date/Time. Access only has one: Date/Time. It appears that a part of the ODBC path from the PC to DB2 inserts the current date for Time fields. I linked the table in Access that I was trying to replicate and noticed the same behavior.
I'll direct this issue to the provider of the ODBC driver.
Thanks for your help!