Is the Access field that isn't importing correctly a MEMO field? If it
isn't, the character limit is not in Excel, it's the 255 character text field
limit in Access that's causing the problem. Excel column width limit is 255,
but the number of characters allowed in a cell 32,767, although Excel will
only display the first 1024 characters.

--
Kevin Backmann


"Paul Dennis" wrote:

I am using the TransferSpreadsheet function in an Access macro to send data
across to an Excel worksheet and all works well apart from one cell. The data
being sent across is over 255 chars and Excel seems to limit the cell to only
255 chars hence I loose the rest of the data.

Is there anything i can do to get around this?