Want dates exported as dates, not strings

J

Judy Ward

I am exporting out a crosstab query from Access to Excel using
TransferSpreadsheet. Most of the column headers are date fields. In the
Excel spreadsheet they all have a single quote in front of them. This
wouldn't matter, but in Excel I'm using this data to create a chart and need
them to be true dates (not strings).

I noticed that if I export out this query manually and check the "Save
formatted" box, the fields are exported out as dates (not strings).

Is there a way to get this result in code? (an argument to
TransferSpreadsheet?)

Thank you for your help,
Judy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exported Excel File is Incomplete 7
Email notifications without opening application 1
Null exported as zero 0
TransferSpreadsheet still truncates the memo field 1
Transfer Spreadsheet into Excel 5
Optionbutton Not working 3
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Dates not showing up as dates 2

Top