Access 2000

[lynn_victoria12047]

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

 

[Rockn]

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

 

[lynn_victoria12047]

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?

 

[Rockn]

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

 

[Anne Troy]

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

 

[downwitchyobadself]

From Excel help:

Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

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

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