exporting memo field from access97 to excel97 truncates after 255 chars

[lesperancer]

I've read all the posts, but nothing works
I've got a table with an ID field and a memo field
one record in the table, with the memo field having 322 chars

I open the table, and then use the office links on the toolbar to
'analyze it with ms excel', but the contents on the excel cell contains
just the first 255 chars

I've also tried, using vba, ie.
.range("A2").CopyFromRecordset Me.RecordsetClone

where the recordset source is the table, same result

what else can I try ? any ideas

[Bob Quintal]

le*********@natpro.com wrote in
news:11*********************@g49g2000cwa.googlegro ups.com:

I've read all the posts, but nothing works
I've got a table with an ID field and a memo field
one record in the table, with the memo field having 322 chars

I open the table, and then use the office links on the toolbar
to 'analyze it with ms excel', but the contents on the excel
cell contains just the first 255 chars

I've also tried, using vba, ie.
.range("A2").CopyFromRecordset Me.RecordsetClone

where the recordset source is the table, same result

what else can I try ? any ideas

The only way to overcome the 255 character limitation is to
write code that gets the field length in access, then loops
(fieldlength mod 255) +1 times and writes the subparts to that
many cells in Excel.
--
Bob Quintal

PA is y I've altered my email address.

[lesperancer]

I'll try that
but after creating the excel worksheet as defined above, I can copy the
complete text (322 chars) from Access and paste it into one excel cell,
so I'm not sure when I need many cells