Martyh
Registered User.
- Local time
- Today, 06:59
- Joined
- May 2, 2000
- Messages
- 196
Hi,
I have a problem when importing excel when the cell is longer than 255 char. The cells are 300-1000 chars long. (Verified by doing a len().)
The problem is that when it is imported into Access --> appended to the table it is truncated at 255 char even though it is a memo field that it is going to. (Verified by doing len() at the other end)
Is there a work around, or am I missing something? Does anyone else have this problem?
Regards,
Marty
PS When I create a new table it seems to work fine. It is only when I append to a table!!
I have a problem when importing excel when the cell is longer than 255 char. The cells are 300-1000 chars long. (Verified by doing a len().)
The problem is that when it is imported into Access --> appended to the table it is truncated at 255 char even though it is a memo field that it is going to. (Verified by doing len() at the other end)
Is there a work around, or am I missing something? Does anyone else have this problem?
Regards,
Marty
PS When I create a new table it seems to work fine. It is only when I append to a table!!
Last edited: