NotesSQL is an ODBC driver for Notes Database(.nsf File). People can leverage it to query a Notes Database through ODBC.
In Excel people can import data from external data sources, so NotesSQL provides a convenient way to transfer data from Notes to Excel.
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