469,282 Members | 1,681 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,282 developers. It's quick & easy.

access 2003: reports export to excel 2003

hello

does anyone know why is there a character limitation (255) in excel
when i export from the reports object in excel access? if i created a
macro using the transferspreadsheet action from the query with the
field of + 255 characters, it will export all characters. why is there
a character limitation in the reports when exporting to excel?

thanks in advance - jung
Nov 13 '05 #1
1 1918
I run into this problem when using A2000 and TransferToSpreadsheet (may not
be exact name). As I recall the problem is that the data is sent to an older
version of Excel (older than 2000) which only accepts 255 characters per
cell. I was hoping to avoid this problem by upgrading to A2002.

--
Karl Irvin
www.q2q.us
"JMCN" <pi******@yahoo.fr> wrote in message
news:27*************************@posting.google.co m...
hello

does anyone know why is there a character limitation (255) in excel
when i export from the reports object in excel access? if i created a
macro using the transferspreadsheet action from the query with the
field of + 255 characters, it will export all characters. why is there
a character limitation in the reports when exporting to excel?

thanks in advance - jung

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

52 posts views Thread by Neil | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.