The user gets the front end of Access 2007 from an outside entity. We have no ability to put code in it to export/create a spreadsheet. She exports data to an Excel 2003 format, which includes dates. She checks "Export data with formatting and layout." and "Open the destination file after the export operation is complete..." She copies rows from that Excel 2003 spreadsheet to another one. The dates in the copied rows turn into a five-digit number, apparently a serial date, in the spreadsheet they are copied into. Sometimes the dates which were already in that spreadsheet also turn into the five-digit numbers. The user formats them as a date, and the dates display as 13- Jan-11. However, after she saves the spreadsheet and reloads it, the dates are back to displaying as serial dates.
She has also tried copying the rows from Access 2007 and pasting them into an Excel 2003 spreadsheet. The result of the process is the same.
What do we do differently?
Tags: Access 2007, Excel 2003
(I was not able to get them put on initially and cannot now while editing.)
She has also tried copying the rows from Access 2007 and pasting them into an Excel 2003 spreadsheet. The result of the process is the same.
What do we do differently?
Tags: Access 2007, Excel 2003
(I was not able to get them put on initially and cannot now while editing.)
Last edited:
