Opening nsf file in Ms-Access

Posted on 2004-08-03
Last Modified: 2013-11-16
The small application which implemented lotus domino file (nsf file), I need to convert it to ms-access, so can any one help me how to see the domino database  (nsf file) in Ms-access 2000. Actually I don't know anything about Lotus Domino designer.
Question by:osmjahir
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
LVL 46

Expert Comment

by:Sjef Bosman
ID: 11703467
Get a Notes client somewhere, and export the data. Or use Lotus Approach, also capable of reading .nsf files. These are the only two ways!

Author Comment

ID: 11711653
Can you explain me how to get the notes client?
LVL 46

Accepted Solution

Sjef Bosman earned 20 total points
ID: 11712984
There are several ways:
- find a company nearby that sells Lotus Notes
- try to download it from the IBM-site somewhere (you can get a 90 days trial version, I think), see

If I may be so bold to ask you: where did you get the .nsf file, if you don't have Notes? And how do you know the application? Note that it might even be difficult to open the database, because you usually need a Notes-ID to get in.

You need a Notes-client to be able to export the data, and a Domino Designer to inspect the design of the application.
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 15

Expert Comment

ID: 11714911
Download the Notes client, and download the ODBC driver for Lotus Notes.  You can now create an odbc datasource to connect to the notes database, but you will still need a notes id !


LVL 31

Expert Comment

ID: 11727707
SO far you are getting advice on how to techincally connect and get access to the data.  An important consideration, and possible a tougher problem, will be the data structure.  Notes is non-relational, and does even use a homogeneous flat file structure.  There is also a tendency among Notes programmers to use data fields for working values, that then get saved with each record (document).  The view structure is most akin to a relational database, but contains a subset of the rows and columns that you might have to translate to.  So, you are probably going to need to deconstruct the Notes database into the core elemnts that need to be exported to Access, and then design a data model to suit.

Of the options given so far, the one most likely to work well for you is Notes client + the NotesSQL ODBC driver.  You can then pull out data by FORM (not by view), and possibly get enough information to do a quick load into Access.
LVL 15

Expert Comment

ID: 11727898
And you are going the wrong way of course :
You should be migrating your access applications to Notes :-)
LVL 31

Expert Comment

ID: 11738760
Most likely, he should be migrating his application to RDBMS with an app server.

Or, better yes, not migrating at all.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question