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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying 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

Suggested Solutions

Title # Comments Views Activity
Email Message Background Color 4 145
Lotus Notes Mail Database issues 2 981
Mobile Iron iphone stop receiving new mails 6 1,435
lotus domino server console error 1 86
This is an old article, please see an updated version of this article, located here:
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
In an interesting question ( here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

730 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