TransferSpreadsheet problem

[ossse]

I am using the TransferSpreadsheet command to send an access query to excel. There are two fields in the query that may contain greater than 255 characters. I am transferring to Excel 97.

When I run the TransferSpreadsheet command and open the excel file, one of the fields is shortened to 255 characters, but the other field can have more than 255 characters.

Does anybody know what is going on? and how I can fix it?

Thanks

 

[Remou]

Here you go:

http://support.microsoft.com/?id=294286

 

[ossse]

The problem was that;

the query that I was exporting had the field as a Text type. This was because I concatenated 2 fields together to create this particular field.

To get around the problem I created a Make Table Query. the Table put this field as a Memo. I was then able to use TransferSpreadsheet to export to Excel.