Ok here it is,

what i need to happen is, i have a form, this consists of mixed fields, Text and Dates, we enter the data, then export the table to Excel, this is then emailed to an outside source, they make their changes on the spreadsheet, Eg. what date a job was done etc. then they email the spreadsheet back and we import the spreadsheet with the new data.

All fields in the table are formatted to text / dates (medium date), but when the table is exported to excel the date formats are changed to custom date format where there is data, and where there isn't data the format gets changed to general.

is there any way of stopping that.

also both excel and access are 2002, when i export to excel, make changes and save, it says that it is a 95 workbook do i want to save it as the current format?

i hope this makes sence please HELLLLLLLLLLP:(:(:(

This is the export code

DoCmd.OutputTo acOutputTable, strTableName, acFormatXLS, strFileName