I have an Access table that I'm exporting to Excel. The date field needs to be in the format of yyyymmdd. I'm having 2 problems:
1. The field shows up in Excel as mm/dd/yyyy.
2. Really old dates (1900 or older) don't get exported and Access creates an ExportErrors table showing these records.
I've tried converting the field to a text type and then exporting, but then I don't get the format I need in Excel.
Would it be better to try and do the conversion to the correct format from within Excel, or can I do it in Access?
Thanks.
1. The field shows up in Excel as mm/dd/yyyy.
2. Really old dates (1900 or older) don't get exported and Access creates an ExportErrors table showing these records.
I've tried converting the field to a text type and then exporting, but then I don't get the format I need in Excel.
Would it be better to try and do the conversion to the correct format from within Excel, or can I do it in Access?
Thanks.