Data missing when pasting from Access into Excel

[Guest]

Hi,

I am trying to copy and paste one row of data from an Access database into
an Excel spreadsheet. Several fields within the database need to allow for
more than 255 characters; those fields are set to Memo. When I copy and
paste the data into the existing Excel spreadsheet, as well as a new,
unformatted spreadsheet, the fields that are set to Memo in Access cut off at
255 characters in the Excel spreadsheet.

How do I fix this?

Thank you!

Stacie

 

[RichardSchollar]

Hi Stacie

Rather than copying and pasting data (or even Tools>Office
Links>Analyze it with Excel), Export the data by going File>Export and
export it as type MS Excel Workbook. This will preserve the entire
data in the memo field.

Hope this helps!

Richard

 

[Guest]

Why don't you let access do the conversion to excel and ten copy the cells.
Access under Tools - Menu Office Links - Analysize it with excel. this will
produce an excel spreadsheet. then try copy the datta and pastting it into
your workbook.

the fields may not be cut off. the data is probabbly there, but you can't
see it. On the excel spreadsheet add the functtion =len(a1) where a1 is a
cell you think is being cut off. If the returned value is greater than 256
than that is a limitation of the number of cells that can be displayed in
dxcel. the cell can contain up to 64,000 character but only the 1st 256 can
be displayed under normal conditions.

 

[Guest]

Thanks for the quick response, Richard.

I like the results I get from Analyze it with Excel, but again facing the
same character cut-off problem. We've done the copy and paste thing in the
past, and didn't have this problem. I exported the data per your
instructions, but the entire database ended up in the spreadsheet. My goal
is to have each row of the database saved as a unique spreadsheet file,
complete with the field headings. We send these files to clients with
somewhat limited computing skills, and have found this to be the easiest way
for them to update information. And given my own computing limitations, it
seemed like a good solution for me, as well.

Any way to isolate each row as its own spreadsheet with the field headings
from Access? The end-product is that I re-paste an edited spreadsheet into a
new version of the same database from which I originally derived the data for
the spreadsheet.

Thanks!

Stacie