Check the table structure of the table that is the source of your query. The
field type is determined there, not in the query or macro. If the field is a
text field, you've maxed out the number of characters in Access.

BTW: What version of Access and Excel are you using?
--
Kevin Backmann


"Paul Dennis" wrote:

Since I'm doing the work in a Access Macro memo isn't available only String.
However String in a macro is unlimited. I used a query in Access to view the
results from the Macro and it returns all the characters, hence this leads me
to believe that it is how Excel received the data that truncates it down to
255.

"Kevin B" wrote:

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?