Hi yall,

I am using the TransferSpreadsheet method in Access 97 to
export a table to Excel 97. My problem is that some data
fields have strings such as 3-3 or 1-3 etc. etc. and Excel
wants to automatically format those fields as dates when
they actually are not. Is there a way I can stop Excel
from automatically formating this type of data as a date
when using the TransferSpreadsheet method?

Thanking you in advance..