Ask the Expert

Exporting Lotus Notes data to Excel

We maintain an incident log of computer problems. Each record is on date/time. There is one long description field. Each week I export the previous week's data to Excel to print as a management report. If I export as csv, the long description is truncated when it exceeds a certain length, and sometimes the gridlines cut the top or bottom text in cells. Neither occurs when I export as .wks but at the end of each cell I get a non printable character rectangle which does indeed print. This can be removed with Excel's CLEAN function, but I have not worked out how to use this function on an entire worksheet. Have you any suggestions on the export that may assist.
I tried this out myself and had the same problem exporting to the Lotus 1-2-3 format. I also found the solution. Make sure to specify the filename when exporting to 1-2-3 format including the extension .wk4. I found the solution using . Try searching for 802564910029BEB5.

This was first published in April 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: