Exporting a report to Excel...

[Raj]

Dear All,

I have an access report exported to a excel spreadsheet. Everything works
fine, but the content data gets restricted somewhere. For eg., I have a
comment field with datatype memo in access, if i export to excel am not
getting the full data exported. I am not sure where am doing wrong.

I would appreciate any help.

Thanks folks..
-Raj.

 

[Guest]

You are doing nothing wrong. Excel will only get the first 256 characters of
a text or memo field.

 

[Raj]

thanks a lot, i was breaking my head for 2 days.

 

[Raj]

is there any method to doo for more than 256 characters?

 

[Guest]

Unless someone wiser than I has a solution, my answer is yes, but it would
not be easy.
The problem is you would have to break the memo field into 256 byte chuncks,
then you would have to test to see if you have an entire word at the end of
the 256 bytes and adjust it accordingly. Then these chuncks would have to be
written to a table so you could feed the report. There would be a couple of
ways to do that, but both would involve serious changes to your report. One
would be to create a query that would create duplicate records for all you
current records with one chunk for each record, and in your report you would
have to tell it not to display duplicate values for all fields except the
memo.
The other would be to create a sub report that uses the table with the
chunks in it.