Import lotus notes view data from Excel

30 pts.
Tags:
Lotus Notes
Microsoft Excel
Microsoft Excel macros
I need to import frequently data from some Lotus Notes views into my Excel sheets, I want to know if they are a macro or a VB script which could do that.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Otherwise, this is a non-script solution available on Domino Power.

Search openntf.org for code that will do that.
The other choice is to select the docs in the view and copy as a table (r7 & up). You can then paste it into excel.

If this is to be done all the time then you can use NotesODBC and have excel pull the data as ODBC, this lets you just do it in excel and not have to export or use com to write directly to excel

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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
  • Witold2008
    Thank you! It is not exactly what I'm looking for but it is very interesting, I will try the Lotus Notes view into an XML.
    30 pointsBadges:
    report
  • SlikTool
    I may have some code that could be used, only it will require Win32 clients only. Most of it is done via COM. Another option, if you are familiar with SQL is to use the NotesSQL driver and connect to your DB via SQL within Excel. I believe here though, you work with the form or the view as a table.
    1,840 pointsBadges:
    report
  • Witold2008
    Thanks for all yours tips, I'm not familiar with ODBC or SQL or COM but I think that my solution is there Actually I need to select docs in view and copy as table and then paste it into excel, but I have 4 table to update like that each time, so I need something to be more efficient. Which of your suggestion is easiest to apply for my case?
    30 pointsBadges:
    report

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

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

Thanks! We'll email you when relevant content is added and updated.

Following