Dates in TransferSpreadsheet macro action

[Frances]

I use Access 2000 and Excel 2000 when I use
TranasferSpreadsheet macro action If the Excel spreadsheet
is closed the dates get imported ok.
However if another user has the spreadsheet open the dates
gets imported as a number.

e.g 07/01/2004 becomes 37993.

Does anybody know a workaround

TIA

Frances

 

[Steve Schapel]

Frances,

I am not sure of the reason for this disparity. The number you are
seeing is the way that Access actually stores dates, i.e. the number
of days since 30 December 1899. You could try formatting the date
within the query that you are exporting from, e.g.
DateForTransfer: Format([YourDateField],"dd/mm/yyyy")

- Steve Schapel, Microsoft Access MVP