hi
I am using the copyfromrecordset method to export my tables to an excel sheet.
My primary key is a field called date which I have formatted as date\time dd/mm/yy in access table design.
When I export the data into excel now,the date column shows up as numbers - 37469 instead of the date.
even though the database contains the correct date
any ideas
I am using the copyfromrecordset method to export my tables to an excel sheet.
My primary key is a field called date which I have formatted as date\time dd/mm/yy in access table design.
When I export the data into excel now,the date column shows up as numbers - 37469 instead of the date.
even though the database contains the correct date
any ideas