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.

"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