How to import data from a Lotus private view into Access?

Posted by PowerUser on Stack Overflow See other posts from Stack Overflow or by PowerUser
Published on 2010-05-26T21:18:55Z Indexed on 2010/05/26 21:21 UTC
Read the original article Hit count: 268

Filed under:

ms-access

|

lotus-notes

|

lotus-domino

I'm experimenting with Lotus private views for the first time and I finally made a private view that (more or less) has the data I want. I just need to get it into MS Access.

If this was a standard shared view, I'd just fire up the ODBC administrator, and make a DSN to the database using the NotesSQL driver. Been there, done that. But you can't get to private views that way. So, how do I import the data from my private view into Access?

(Also, I'm not one of the IT gurus in our company, so I can't just make a view and share it, even if it's hidden)

© Stack Overflow or respective owner

Related posts about ms-access

SQLAuthority News – MS Access Database is the Way to Go – April 1st Humor

as seen on SQL Authority - Search for 'SQL Authority'
First of all, today is April 1- April Fool’s Day, so I have written this post for some light entertainment. My friend has just sent me an email about why a person should go for Access Database. For a short background, I used to be an MS Access user once (I will not call myself MS Access DBA), and… >>> More
LINKED TABLES BETWEEN MS ACCESS 2003 AND MS ACCESS 2007-WRITE PERMISSIONS DENIED

as seen on Super User - Search for 'Super User'
We are in the process of switching over to ACCESS 2007. We have numerous data tables in ACCESS 2003 files. In one case, the user has 2007 on his PC and opend the front end in 2007. No problems. When the the user is done, he clicks a button that executes a macro full of update queries. The macro… >>> More
Working with Compressed (zipped) folders in MS Access

as seen on Internet.com - Search for 'Internet.com'
Doug Steele presents a simple technique to add zip files from within your application. >>> More
Extending the InputBox function for MS Access Forms

as seen on Internet.com - Search for 'Internet.com'
While it's not possible to change the behavior of the InputBox function, this article illustrates how to create your own Access form that includes a text box with its InputMask property set to Password, and then use that form instead of the one generated by the VBA InputBox function. >>> More
Uses for Cartesian Products in MS Access

as seen on Internet.com - Search for 'Internet.com'
Less well known than inner and outer joins is the Cartesian product, which produces every possible combination of records between the two tables. Doug Steele offers four examples to demonstrate some legitimate uses for Cartesian products. >>> More

Related posts about lotus-notes

Access to content of Lotus Notes database without Lotus Notes software installed

as seen on Stack Overflow - Search for 'Stack Overflow'
I am looking for a programatic way to access content in a Lotus Notes database (.nsf file) without having Lotus Notes software installed. Python would be preferred but I'm also willing to look at other languages e.g. C/C++ or other means e.g. SQL From what I have read, all of the methods e.g. Python… >>> More
Extract inline images from Lotus Notes using Lotus Notes Java API

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm having issues to extract inline images that are pasted in the email body if the emails are sent from external email(like gmail for example) into the Lotus notes. The emails which are sent from Lotus Notes itself has no issues and I'm able to retrieve the inline images by using the document.generateXML()… >>> More
Transfer address book from Lotus Notes to Outlook

as seen on Server Fault - Search for 'Server Fault'
Is there a way to transfer the address book (contacts) from Lotus Notes 8.0 to Microsoft Outlook? >>> More
.NET and Lotus Notes Interop.

as seen on Stack Overflow - Search for 'Stack Overflow'
I've Lotus Notes database file (.nsf) at some location, let's say: http://intranet.mycompany.com/somewhere/data.nsf Is it possible in any way to read from that location using any .NET language? >>> More
Is there a good Lotus Notes open-source alternative?

as seen on Super User - Search for 'Super User'
At my work we use Lotus Notes 6.5 for our email, meeting scheduling and instant messaging. I can't stand the horrible UI, buggy meeting scheduling and overall '90s feel when using it and would love to replace it with open-source alternatives. So far I've been able to setup Thunderbird for email,… >>> More