Exporting Data from Access

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

onedaywhen

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.
 

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

VBA - exporting serial letters to single documents 0
Paste to excel from word - auto format problem 1
Exporting data from MS-Access to Excel 4
Publisher is filling blank lines with data 2
ASK Field Formatting 1
Export Report with Graph to Excel error 2495 1
TransferSpreadsheet method 0
export excel data to access table using ADO 0

Top