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

Question

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)

Answer 1

If it is just a one-time import, you can just open the view, select all the documents, and then click Edit > Copy Selected As Table. Then paste the contents into an Excel Spreadsheet and import that spreadsheet into Access.

If you're looking to have a constant connection from Access to data in Notes, you'll want to change the view to a public view. In that case, see if one of the IT gurus can help :)