<div>
You need some kind of notes connector to access the Notes DB.<br />
<br />
see<br />
<br />
<br />
<a href="https://www.experts-exchange.com/questions/20708795/Problems-resolving-table-name-in-Notes-via-ODBC.html" rel="ugc">https://www.experts-exchange.com/questions/20708795/Problems-resolving-table-name-in-Notes-via-ODBC.html</a><br />
<br />
<a href="https://www.experts-exchange.com/questions/20582200/Error-Copying-large-table-between-Notes-and-Sql-via-ODBC.html" rel="ugc">https://www.experts-exchange.com/questions/20582200/Error-Copying-large-table-between-Notes-and-Sql-via-ODBC.html</a><br />
<br />
<br />
<a href="https://www.experts-exchange.com/questions/23006564/How-to-connect-to-lotus-notes-client.html" rel="ugc">https://www.experts-exchange.com/questions/23006564/How-to-connect-to-lotus-notes-client.html</a><br />
<br />
<a href="https://www.experts-exchange.com/questions/20454464/Writing-to-Lotus-Notes-via-ODBC-NotesSQL.html" rel="ugc">https://www.experts-exchange.com/questions/20454464/Writing-to-Lotus-Notes-via-ODBC-NotesSQL.html</a><br />
<br />
<br />
I hope this helps !
</div>


You need some kind of notes connector to access the Notes DB.

see


https://www.experts-exchange.com/questions/20708795/Problems-resolving-table-name-in-Notes-via-ODBC.html [https://www.experts-exchange.com/questions/20708795/Problems-resolving-table-name-in-Notes-via-ODBC.html]

https://www.experts-exchange.com/questions/20582200/Error-Copying-large-table-between-Notes-and-Sql-via-ODBC.html [https://www.experts-exchange.com/questions/20582200/Error-Copying-large-table-between-Notes-and-Sql-via-ODBC.html]


https://www.experts-exchange.com/questions/23006564/How-to-connect-to-lotus-notes-client.html [https://www.experts-exchange.com/questions/23006564/How-to-connect-to-lotus-notes-client.html]

https://www.experts-exchange.com/questions/20454464/Writing-to-Lotus-Notes-via-ODBC-NotesSQL.html [https://www.experts-exchange.com/questions/20454464/Writing-to-Lotus-Notes-via-ODBC-NotesSQL.html]


I hope this helps !

<div>
<div class="content wysiwyg-content">
Hello all, any help or guidance is appreciated<br />
<br />
What I intend to do is<br />
<br />
Use Microsoft Access to retrieve Data from LN Databases<br />
<br />
1) Use VBA code within a MS Access Form<br />
2) Connect to LN DB &nbsp;on the network (nfs file)<br />
3) Retrieve the desired data from the LN DB<br />
4) Put the retrieved data into tables in access<br />
<br />
Ive seen a lot of code around here but I wonder if someone can enlighten me with the general paradigm on how to do so, mainly Connecting to Notes and reading de Database data is my concern.<br />

</div>
</div>


Hello all, any help or guidance is appreciated

What I intend to do is

Use Microsoft Access to retrieve Data from LN Databases

1) Use VBA code within a MS Access Form
2) Connect to LN DB  on the network (nfs file)
3) Retrieve the desired data from the LN DB
4) Put the retrieved data into tables in access

Ive seen a lot of code around here but I wonder if someone can enlighten me with the general paradigm on how to do so, mainly Connecting to Notes and reading de Database data is my concern.


How do I retrieve/export Lotus Notes DB data through Access 2000?

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.