I am querying a worksheet using ADODB via Microsoft.Jet.OLEDB.4.0. The tool was working fine previously but since reopening it, one column now always results in a NULL return despite having data. The other columns return fine. The column in question is a time formatted column. When I checked the formatting of the column, excel has added a .PD suffix. If I go to the HOME ribbon and select the format list, it shows time as 08:30:00.PD. When selecting that format any column for time formatting will now place .PD after the time. This is the auto excel Time format, not a custom one.
Anyone know why it is doing this?
Anyone know why it is doing this?