TransferSpreadsheet method

D.Mulder

Guest

Posts: n/a

5th Mar 2004

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

« Retrieve data from a corrupted database | Access97 snapshot to OE, problem »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: Question on the TransferSpreadsheet method	John Nurick	Microsoft Access External Data	0	25th Jun 2004 07:23 AM
TransferSpreadsheet method	=?Utf-8?B?Q2hyaXM=?=	Microsoft Access External Data	3	26th May 2004 02:43 PM
DoCmd.TransferSpreadsheet method question	Stuart	Microsoft Access External Data	2	20th Apr 2004 07:46 PM
Specify named range for transferspreadsheet method	Shaggles	Microsoft Access Reports	1	3rd Mar 2004 09:50 PM
how to rename sht after TransferSpreadsheet method?	Rich	Microsoft Excel Programming	2	8th Dec 2003 07:57 PM