When exporting data from Access to Excel, Time Field is blank
Posted on 2009-05-08
I am using the DoCmd.TransferSpreadsheet command to transfer 16 data items in a single row of an Access table to the spreadsheet of an Excel Workbook (Headers from A1:P1, Data from A2:P2). All data is properly exported to Excel except for the field "TIME", which holds the time the incident occurred in HH:MM "LL" ("LL" standing for AM or PM). The field header exports fine to cell C1, but the cell where the actual time value should be, C2, is completely empty. Any idea why only this one piece of data would not be exported?