TransferSpreadsheet method

D

D.Mulder

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..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TransferSpreadsheet method 3
Want dates exported as dates, not strings 0
Alternative to TransferSpreadsheet 2
Paste to excel from word - auto format problem 1
Exporting Data from Access 1
TransferSpreadsheet still truncates the memo field 1
Getting -0 for 0 in Excel When using Transferspreadsheet 2
TransferSpreadsheet to colored fields 0

Top