Access 2000

In exporting a Access 2000 querie to Excel 2000, I have an Access field that is formatted as Memo, that Exel is truncating. Does anyone have an explanation, or a way to keep this from happening? Thanks

 

Memo fields are more than 255 charachters long. I believe Excel will truncate after 255 charachters. I think that is correct, but I could be wrong. Looked in Help and saw :
Column width 0 (zero) to 255 characters

 

Yes, While that is true, I can only find, txtparsefile to set column size when importing from a .txt file. How can I fix this to accept in the size of the Memo field from Access? Any other ideas?

 

You can't! That is the way Excel was designed....I know you can physically insert or type more than 255 charachters by typing.

 

Well, in Access, you could first break up the memo field by doing an LEFT and MID in a make-table query that adds the necessary columns for the continuing text, and export THAT instead, no?

I guess you'd have to find out the largest amount of characters first...

 

From Excel help:

How much of your memo field is making it in? Have you checked the formula bar for the cell(s) in question? You can copy the text, open the immediate window of Access (CTL+G), and type

Code:

?Len("my copied text")

to see how many characters you're getting. Where my copied text is what you got in Excel, of course. Don't forget the quotations around it.