copy and paste from datasheet to excel

[Nathan]

I am trying to copy data from a datasheet from into excel. All seems to go
well (no error messages) but when I paste in excel, I am only getting a
portion of my data in one particular field. When I try to just isolate that
one field and copy/paste it, its the same thing. I've also tried exporting
via OutputTo and TransferSpreadsheet macro commands, with the same result.

This field is a memo in access, and there are hard returns. I don't know if
either of these facts is causing the problem. There is no particular rhymre
or reason to where the data cuts off (its not a a certain hard return where
its clear the data cuts off), so its very odd. Any ideas?

 

[MikeJohnB]

There is a string length limit of 1024 character (iirc). If you try to put
more text that that in one cell Excel will get mad at you. What are you
trying to do exactly, there may be a better solution.

The above was googled on "Excel Cell Contents Limit" But as it says, The
limit is 1024 Characters whereas

Number of characters in a Memo field: "65,535 when entering data through the
user interface; 1 gigabyte when entering data programmatically."

So you see, the text will no doubt be truncated at what appears to be random
lengths indipendant on the Hard Line Feeds.

Try
=Len(A1)

Where A1 is where you have pasted the contents of the memo field? What is
the answer? 1024?

I hope this helps you a little but I guess it doesn't answer your question?

Seasons greetings

 

[Nathan]

The Length of this particular field is 255; thats where it cuts off the
paste in excel.

Whats weird is that the original source is an excel sheet, with all the hard
returns and whatnot, so I know it fits in excel, its just the extracting BACK
to excel via copy/paste is the problem.

Honestly, I can't explain what I am really trying to accomplish. They want
the data in a database, then want to see it in a datasheet (following a query
on a few things), then they want to copy and paste it back to excel. its
stupid and a waste of time, but thats what my customer wants, so I'mg trying
to accomodate.

 

[MikeJohnB]

Ok Nathan,

I have Replicated the truncation of text when copying and pasting from a
table, and from a datasheet form and these are my findings for what they may
be worth.

1. Copying and pasting direct from the clip board to Excel

Header Pasted (Field Name) in Cell A1 (Strange)
Text in cell A2 forms the contents of the Memo Field, Control but is
trucated at 255 Characters for some reason.

2. Copying from DataSheet

Paste Special (Text)
Pastes the Header (Field Name) in Cell A1
The whole of the memo field is then pasted in Cell A2 (320 Characters with
various hard line breaks)

That is how far I have got so far, will try exporting as soon as I finished
Tea Break here LOL

 

[Fred]

One sidebar thing to check.....

Make sure that the missing text is really truncated and not just hard to
see. For example, invisible after the line breaks unless you arrow down to
look at it.