Ask the Expert

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: