docmd.TransferSpreadsheet

[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.

 

[Guest]

Because that is the maximum size of a text field in an Access table.

 

[Guest]

So it doesn't matter if it is a memo field or not?

 

[Guest]

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.

 

[Ken Snell \(MVP\)]

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.

 

[Guest]

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.

 

[Ken Snell \(MVP\)]

Old habits die hard.

I won't discuss my old habits here..... < g >

 

[Guest]

Agreed <g>
--
Dave Hargis, Microsoft Access MVP

I won't discuss my old habits here..... < g >