docmd.TransferSpreadsheet

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

Guest

When using the TransferSpreadsheet to export data to Excel, text is limited
to 255 char. Is this a bug? Is there a work around? An Excel cell will hold
more then 255, so why won't it transfer more then 255 chars.
 
I am not sure on this one. I think it will still transfer only the first 255
characters.
I would test it, but I don't have any memo fields in my tables.
 
TransferSpreadsheet will export all the contents of a memo field if you
export from a table or from a query that has no group by or functions in it,
so long as the EXCEL version being used is at least ACCESS 97 or higher.

The usual cause of the truncation is because a query is being exported. If
this is the case here, Charlespolkaz, please post the SQL statement of the
query so that we can see what the source of the truncation is.
 
Thanks, Ken.
Interestingly, I have never created an app where the user wanted a memo
field. I have sort of avoided them because in my old FoxPro experience,
there were issues with them. Old habits die hard.
 
Back
Top