max char export

[blackcat]

i have exported some fields from a database to excel using a query and a
macro, one of the fields is set up as a memo to allow the user to enter title
blirb, once this field is exported to excel, it cuts some of the blirb off -i
take it there is a max of 255 characters which can be exported, is there any
way to increase this

 

[fredg]

i have exported some fields from a database to excel using a query and a
macro, one of the fields is set up as a memo to allow the user to enter title
blirb, once this field is exported to excel, it cuts some of the blirb off -i
take it there is a max of 255 characters which can be exported, is there any
way to increase this

Form Excel Help
Length of cell contents (text) 32,767 characters. Only 1,024
display in a cell; all 32,767 display in the formula bar.

It's probably your query that is truncating the Memo field.
Post the query SQL.

 

[Douglas J. Steele]

Form Excel Help
Length of cell contents (text) 32,767 characters. Only 1,024
display in a cell; all 32,767 display in the formula bar.

It's probably your query that is truncating the Memo field.
Post the query SQL.

I believe, though, that it depends on the version of Excel, Fred. That's the
maximum, but older versions, I think, did have a 255 character limit

 

[fredg]

I believe, though, that it depends on the version of Excel, Fred. That's the
maximum, but older versions, I think, did have a 255 character limit

Doug,
I'm either too young to remember 'older versions' or too old to
remember them. I can't remember which.