max char export

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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.
 
fredg said:
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.
Click to expand...

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
 
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
Click to expand...

Doug,
I'm either too young to remember 'older versions' or too old to
remember them. I can't remember which. :-)
 
Back
Top