Exporting data to Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following problem ...

When copying data from a Memo field (more than 255 characters) in Access to
a spreadsheet cell, I lose some of the data; it's being cut off. Is this a
problem with a limit to cell size or is it due to a size limit for the Text
data type in Excel? This also happens when I export the query as an Excel
file.

Does anyone have any helpful suggestions?

Thanks ...
 
CCLEM,

Had same problem. While there may be a better solution, I parsed the
strings at 255 and made multiple fields to export to excel. I then
concatenate them when importing. Boring but functional.

Jael
 
Back
Top