Tech Support Guy banner
Status
Not open for further replies.
1 - 6 of 6 Posts

·
Registered
Joined
·
123 Posts
Discussion Starter · #1 ·
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 :)
 

·
Registered
Joined
·
21,334 Posts
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
 

·
Registered
Joined
·
123 Posts
Discussion Starter · #3 ·
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?
 

·
Registered
Joined
·
21,334 Posts
You can't! That is the way Excel was designed....I know you can physically insert or type more than 255 charachters by typing.
 

·
Registered
Joined
·
11,755 Posts
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...
 

·
Registered
Joined
·
941 Posts
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
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.
 
1 - 6 of 6 Posts
Status
Not open for further replies.
Top