Export to Excel string fields larger than 255

[metaltree]

I can't export to Excel anymore than 255 caracters for a memo type field.

In the online help for Access, they talk about this problem, but do not suggest any way to solve it.

Has anybody been able to do that?

Thanks,

 

[Remou]

Are you using a table, rather than a query? Are you using TransferSpreadsheet?

 

[SkipVought]

Hi,

I can QUERY Access from Excel and return a MEMO field in excess of 1,400 bytes.

Skip,

_[red][/red]

 

[CautionMP]

metaltree,
[tab]Two thoughts:
[ol][li]Create the query in Excel that pulls the data from Access as SkipVought suggests.[/li]
[li]Create your own export routine in VBA (thread705-1260935 : Export A Dynamic Query TO Excel)[/li][/ol]

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[Remou]

I find that TransferSpreadsheet run with a table or simple query works fine. (Access 2000)

 

[NewYorkFashionToGo]

I have been able to export 25,000+ characters in one cell in access, I was only able to achieve this running an append query to a table and then export it. If a ran a query to another query and then append it , It didnt work for some reason. I had to do it in one shot. I also export it in Xls format into excel then have some code that changes it to what I want. When you append it to the table make sure that your appending it to a memo field.