Ask the Expert

Exporting data from Microsoft Excel to Lotus Notes

I want to export data from Microsoft Excel into a Lotus Notes application. What is the limitation on the format of the Microsoft Excel spreadsheet design (layout), and where can I find more information or tips about doing this?

I don't know what you mean by the limitation on format of Microsoft Excel layout. You can check out the various Microsoft product and support sites for further information.

If your spreadsheet has rows of data that will be imported into individual Lotus Notes documents, you can import the file from the Lotus Notes menu.

There is a tip, Export any view to Excel that shows how to create a Microsoft Excel file from a view and populate the rows of the spreadsheet. This covers a lot of what you may want to do. Of course, you'll need to adapt the code to your purpose.

In addition, there is a Featured Topic, LotusScript and Excel that has links to many other examples.

Do you have comments on this Ask the Expert Q&A? Let us know.

This was first published in May 2006

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: