Reformat dates in imported spreadsheet problem

[beatleman]

Hello, Could someone advise me how to fix this little problem i have when importing a spreadsheet. My app outputs two columns into a spreadsheet with the following US date formats.

The spreadsheet it generates is called dates.xls, and i need to re-arrange all the dates in the spreadsheet to a British date format dd/mm/yyyy and re-save it as dates.xls from a click of a button on my form.
I know i can use text to columns in excel to fix this problem, but i want access to do it for me, preferbly in VBA, as in the future i may be working with multiple columns. Thankyou for any suggestions.

20070612 20070112
20070529 20070319
20070530 20070406
20070530 20070406
20070530 20070406
20070530 20070406
20070530 20070406
20070518 20070406
20070525 20070415
20070521 20070419
20070608 20070430

 

[RuralGuy]

Have you tried using Left() Mid() and Right() along with DateValue or DateSerial to get the results you need?

 

[The_Doc_Man]

Or directly output the dates via the Format$ function in the exact order and punctuation as you desire, using a query if necessary rather than table export.