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

"RichardSchollar" wrote:

Hi Stacie

Rather than copying and pasting data (or even ToolsOffice
LinksAnalyze it with Excel), Export the data by going FileExport and
export it as type MS Excel Workbook. This will preserve the entire
data in the memo field.

Hope this helps!

Richard


On 5 Mar, 19:54, NPDPallotti
wrote:
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