I am unhappy with the Access Transferspreadsheet and OutputTo actions because
they cutoff text at 255 characters. I've written my own routine to export an
Access table or query to an excel spreadsheet, and it is working relatively
well.

However, I have found that it is not formatting my data correctly.
Specifically, my Date fields are not being formatted as dates, but as
integers. Assuming that I have a worksheet object (xlWks), how do I format
Column 6 to display in a date format ("mm/dd/yyyy")?

Thanks
Dale