I got a crazy excel file I'm linking to a Access table. There are 4 columns with dates on the report that look like this
1100106 which is really 01/06/10 (Jan. 6, 2010)
I really need them to be in the form of 01/06/10, I can not change the excel file format it has to stay the same format for...