Q

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

Dig deeper on Domino Resources - Part 7

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchWinIT

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchVirtualDataCentre.co.uk

Close