I think MartinW has found the definitive answer. Now, depending on the
amount of text in the existing Approach comment (memo) fields, that data may
not pull into Excel smoothly in the .xls format - but I'd give it a try
first. If things get weird on you, then try using the .CSV format. The .CSV
format will preserve all of the text within it and it is a file format that
Excel can open with no effort and it may give slightly better results than
the .xls format.

If you guys get into this and it really starts giving you any headaches, I'd
be more than happy to try to help come up with a way to get it from a .csv
file into Excel if those memo fields are getting broken up or lost. You can
reach me at (remove spaces) HelpFrom @ jlatham site.com if you need to. But
I'm thinking that either the .xls or the .csv export is going to pull right
into Excel without problem. You'll probably want to do some formatting of
the cells that those long comments get pulled into after the import: turning
'Wrap Text" on (using Format | Cells | Alignment) and making the column wider
and rows taller to see more of it at once.

"MartinW" wrote:

Hi Jack,

I found this in a Google search 'lotus approach to excel'
along with quite a lot more.
http://www.smartcomputing.com/editor...4r04.asp&guid=

HTH
Martin