Problem with text in cell

[JWS315]

I am creating an Excel worksheet from data in an Access table. I have a text
field in Access that I use to populate a cell in the worksheet but only part
of the characters are populated, the last few characters are dopped. Is
there a limit in the number of characters in a cell or am I doing something
wrong? Here is the code that I use:

cellRef = "G" & recNum
xlsWorksheet.Range(cellRef).Text = tmpString

tmpSting holds the value from the Access db and is a String type.

Thanks for any help!

 

[JWS315]

I am using this code, not the .Text:
xlsWorksheet.Range(cellRef).Value= tmpString

 

[Noëlla Gabriël]

hi,

the string type is limited to 255 chars, however i always limit it to 250 to
avoid exchange problems with other databases