Lotus Notes ODBC not found on Windows 10

Question

User want me to update Lotus Notes data through an excel file. One way for me to do this is to import the excel data read through it then do an update. Unfortunately my machine (Windows 10) has no ODBC of Lotus Notes(8.5 ver) therefore I cant connect to the DB and do some update queries. Tried to search in google but I cant find any LN ODBC installer. Does windows 10 still support this ver. of Lotus Notes? Also, is there any other way that I can update the LN Data through imported excel data?

Thanks in advance for your response.

Answer 1

The Notes ODBC driver has always been an extra installer that has to be downloaded from IBM. You need credentials and a passport advantage contract or something similar to be allowed to download the driver. But there are a lot better ways to update Notes Databases from an excel file: use COM or OLE classes to directly write to the database.