MS Access and Export to Excel

[lucas.gadouchis]

When export from MS Access to Excel, when I have large memo field
length, I can not seem to be able to wrap the memo once in Excel.
I can see all the Memo in the field once in Excel, but just a format
issue. Any suggestions?

 

[Klatuu]

You cannot do formatting of a memo field when exporting to Excel. You would
have to either do the formatting in the spreadsheet or use automation to open
the spreadsheet as an excel application object and manipulate the formatting
using VBA.

 

[lucas.gadouchis]

You cannot do formatting of a memo field when exporting to Excel.  You would
have to either do the formatting in the spreadsheet or use automation to open
the spreadsheet as an excel application object and manipulate the formatting
using VBA.
--
Dave Hargis, Microsoft Access MVP





- Show quoted text -

Dave,
Thank you for your help. I tried formatting while in Excel using the
"Wrap" feature and for some reason all the text does not display. When
I click on field in Excel, I can see all the text. I can manually
format the Excel cell, but when you dealing with hundreds of lines,
not viable. Any other ideas?

 

[Klatuu]

Have you tried applying the formatting to the entire column?
If that doesn't work, you may want to consider asking this question in an
Excel group. There are people there with much better knowledge of Excel that
I have.