Access 2000

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

lynn_victoria12047

Thread Starter
Joined
Jan 15, 2001
Messages
123
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 :)
 
Joined
Jul 29, 2001
Messages
21,334
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

Thread Starter
Joined
Jan 15, 2001
Messages
123
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?
 
Joined
Jul 29, 2001
Messages
21,334
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

Anne
Joined
Feb 14, 1999
Messages
11,749
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...
 
Joined
Oct 13, 2000
Messages
941
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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top