Exporting Lotus Notes data to Excel (Part II)
Note: This is a follow-up to: http://searchdomino.techtarget.com/ateQuestionNResponse/0,289625,sid4_cid465134_tax282450,00.html
When I try what you suggested, my long description is truncated. Any ideas? This has been a long-standing reporting issue that I have never been able to deal with successfully. So, I was very excited by your initial answer, then disappointed when truncation still occurred.
Did you have a choice in the Excel File | Open dialog that specified "Lotus 1-2-3 *.wk4"? My only selection is "Lotus 1-2-3 *.wk?", which may have something to do with it, but I don't know.
Also, I remember back in 1996 there used to be a Lotus add-in of some type that allowed me to export views as Excel files, but don't remember why I no longer use or even have it. I think when Excel went from V6 to V7, the add-in no longer worked. Any ideas?
I do NOT have a wk4 save option. What I do is to export using the "Lotus 1-2-3 *.wk?" option and then in the export file name I make sure to have the .wk4 file extension.
What you need to know is that this has nothing to do with how Notes exports. What is important is that Excel when importing sees that the file has the wk4 extension and then uses a newer filter than if the extension was something else. Basically Excel determines what import filter to use based on the extension.
This was first published in May 2002