OK, I got it.

And that without your help!!!(Proud!).

Here's my solution.

If you get the Memo field that is very long(important!!) from Access and
insert it in a cell, Excel will give you #Value! error, the error message of
which is 2015(?? as I recall).

So, I fumbled around and tried to transfer all the data extracted from
Access into Arrays, one of which is one-dimensional and the other is
two-dimensional. And then I tried to insert the array data into cells.

Voila, I didn't get the #Value! error.

I believe that by transferring the data from Access directly into Excel
cells, you are being imposed of some limitations, which I don't know. But by
transferring the Access data into an array or arrays, you will clean the
data ****-free and insert them into Excel cells without hassle.

Thank you all.

Suk Ho


"Sean" wrote in message
...

Ok, Question ...


1) What is the result of inserting the memo text into a
textbox? Is the text trunckated?
2) Check that you are pasting the memo field content and
not the object pointer or the object itself!

What are your findings?

Sean

-----Original Message-----
Dear Colleagues;

Please forgive me if I'm posting this on a wrong
newsgroup but I'm trying to
extract data from Access into Excel.

When I get a data from a Memo field, whose string is very
long(no problem
with short Memo field data), and insert it in a cell of a
worksheet in
Excel, the cell displays #Value instead of its actual
value.

I belive this is a limitation of a text in a cell of
Excel. Is there a way
to go around this problem?

On 2nd thought,

I'm inserting a very long text from a TextBox control on
a UserForm into a
cell without a problem.

Then it may not be with the cell length limitation.

Then I'm totally lost. Please Helpppp!

Suk Ho


Thank you

Suk Ho




.