Truncated Excel 255 chars

[meyerryang]

I have a field in a query that may have more than 255 chars, because it is a
memo field (for notes, etc). How do I prevent it from being truncated with
an export to excel function.

I have used both the transferspreadsheet and output to method. Anyone know
what I can do to prevent this?

docmd.tranferspreadsheet acexport, acspreadsheetTypeExcel7, "MyQuery",
"C:\Documents and Settings\MyQuery.XLS, Yes

 

[Stefan Hoffmann]

hi,

I have a field in a query that may have more than 255 chars, because it is a
memo field (for notes, etc). How do I prevent it from being truncated with
an export to excel function.

Memo fields are truncated when a GROUP BY is applied on it. Create a new
query and join your existing query with the table where the field is
stored. Select the field from the table.

If your using Access 2000:

http://support.microsoft.com/kb/281153

Also changing the Excel type should work:

DoCmd.TranferSpreadsheet _
acExport, _
acSpreadsheetTypeExcel9, _
"MyQuery", _
"C:\Documents and Settings\MyQuery.XLS, _
Yes


mfG
--> stefan <--

 

[meyerryang]

I appreciate the feedback, however the query is not using any GroupBy
functions, etc. There is an order by (sorting by Date). Is that going to
make a difference.

I am running 2000. I tried exporting to excel version 9, but the problem
persists. Any other ideas?

Very simple query:
SELECT MYTABLE.ID, MYTABLE.DATE, MYTABLE.NOTES
FROM MYTABLE
ORDER By MYTABLE.DATE DESC;

 

[meyerryang]

Duh, I forgot to delete the old spreadsheet. That's why is appeared to not
work.

Thanks Stefan. Changing the format to version 9 worked perfectly.