Exporting data to Excel?

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 ...
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
EXPORT QUery with memo field to excel, truncated data 2
exporting data to Excel 1
export access memo fileds to excel 2
Exporting to Excel 2007 1
Exporting data between excel files 1
Export and Analyze With error 1
can i extend the default limit of 256 bytes on memo fields? 1

Top