If you are doing this from within Access97 using a method of the MS
Access object library, you should be asking, 'How can I get MS Access
to format this type of data as a string when using the
TransferSpreadsheet method?' And such a question would get a better
response in a MS Access forum.

--

from automatically formating this type of data as a date
when using the TransferSpreadsheet method?

"D.Mulder" wrote in message ...
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..