Importing Lotus Notes Data(view) into Access Database

HCL Domino Domino Forum
1

Hi,

Is there any way or free software that could shift data from lotus notes view to Access database table.

Imtiaz

2

Subject: Importing Lotus Notes Data(view) into Access Database

The cheapest, easiest method is the NotesSQL ODBC driver. Install it, create a DSN, and then import your Notes views into Access tables.

3

Subject: Importing Lotus Notes Data(view) into Access Database

There are a number of options that come in the box with Notes:

  • You can export a view to any of several file formats although Access is not one of these - look under exporting in Designer Help.

  • You can use the Lotus Connectors to export directly to Access 2000, skipping the interemediary export file. Look under Lotus Connectors in designer help. The connector to use here is the OLE DB connector which actually comes with Windows not Notes - Lotusscript exposes it as a scriptable object you can use from the client or the server.

  • If it’s not Access 2000 you can use the LSXODBC, the Lotusscript ODBC extension which works pretty much the same but requires a DSN.

  • You can use the NotesSQL driver to expose the Notes database as an ODBC data source and then pull the data in from Access. This might be a good option if you are more familiar with Access than with Notes. Be advised the NotesSQL driver used to be rather, um, quirky, though the last time I used it was years ago and it has been updated since.