swaybright
Technical User
Hi all,
This is my first post in this forum.
I am trying to get data from a notes view into MS Access. The problem is, I created the view and only had the option to make it private. So I don't know how to find it using ODBC.
Ultimately what I want to do is locate a document within LotusNotes and retrieve information from fields within the document. I have been successful in retrieving column data from existing views within the desired database (views created by the LotusNotes gods of our company), but I can't get the field values. My understanding is that field data cannot be retrieved using VBA. So I thought that I would create my own view and include in the columns the desired data...problem is a private view cannot be searched (???). So now I am trying to import that private view into Access using NotesSQL driver, but I cannot locate the view.
Please Help!!
Thanks,
Shane
This is my first post in this forum.
I am trying to get data from a notes view into MS Access. The problem is, I created the view and only had the option to make it private. So I don't know how to find it using ODBC.
Ultimately what I want to do is locate a document within LotusNotes and retrieve information from fields within the document. I have been successful in retrieving column data from existing views within the desired database (views created by the LotusNotes gods of our company), but I can't get the field values. My understanding is that field data cannot be retrieved using VBA. So I thought that I would create my own view and include in the columns the desired data...problem is a private view cannot be searched (???). So now I am trying to import that private view into Access using NotesSQL driver, but I cannot locate the view.
Please Help!!
Thanks,
Shane