Lotus NotesSQL is an ODBC driver for Notes Database(.nsf File). People can leverage it to query a Notes Database through ODBC. It provides a convenient way to transfer data from Notes to other applications. Here we take MS Excel as an example to show how easy it is.
1, Install NotesSQL. It can be downloaded fromNotes Toolkit
2, Add a data source from ODBC Administrator
Select "Lotus Notes SQL Driver (*.nsf)" as driver.
Input data source name, server name and db file. You can also provide user name and password.
3, From Excel menu - Data->Import External Data->Import Data...
Select ODBC DSN as source type
Select ODBC data source
Select the object you'd like to import
Give the source a file name then "Finish"
Select the file you just saved as source, then "Open"
Select where you would like to put the data to
Then you can see the data