Convert Lotus Notes .NSF file into Access Database (1 Viewer)

[Trevor G]

I have been request to see if this is possible.

Convert a Lotus Notes Database with an extension of .NSF into an Access Database through VBA. I have seen that some websites are offering software to do the convert but I have been asked not to use 3rd party software.

If anyone can point me in the right direction that would be very useful.

 

[mdlueck]

Lotus Notes is a document database. Notes documents could be equated to RDBMS records.

Lotus Notes has vast capabilities for programming within NSF databases.

You should start by documenting the existing NSF database, logic flow, business rules / logic, etc...

And MS Access is far smaller / less scalable than a Lotus Notes server based application. Perhaps consider a client/server replacement to Notes, where some SQL back end is the true data storage, and Access is merely the front-end to put a pretty interface on the application.

 

[Trevor G]

Michael thanks for the first step. I understand that Lotus Notes is a document tool that is far better than an Access database, it is the code I need to get into the Server and Lotus notes to grab the documents and copy them into Access.

I came across this which will help me a little, but I need to make sure I am comfortable with the interigation and manipulation.

Function GetFromLotusDocs() As String
Dim NtS As New NotesSession
Dim NtDb As New NotesDatabase
Dim NtF As New NotesForm
NtS.Initialize
Set NtDb = NtS.GetDatabase("MyServer", "MyDB.nsf")
Set NtF = NtDb.GetForm("MyForm")

For each document in NtDB
DoCmd.RunSQL _
"INSERT INTO TmpTbl ( Fld1,Fld2,Fld3 ) SELECT " & _
Fld1 & "," & Fld2 & "," & Fld3 & ";"
Next document
End Function

 

[mdlueck]

Oh, I have no idea about automating Notes via OLEAutomation. I just happen to rely on a few Notes document databases of my own.

 

[Trevor G]

Ok thanks for partaking in this thread.

 

[bobalston]

I have done this. I found I needed to copy the NSF file and then work from the copy to avoid conflicting with Notes users.

email me offline for a copy of my code.

bobalston9 AT y a h o o DOT c o m

 

[b3llizzi]

I have done this. I found I needed to copy the NSF file and then work from the copy to avoid conflicting with Notes users.

email me offline for a copy of my code.

bobalston9 AT y a h o o DOT c o m

Bobalston9, I'm looking to transfer a lotus database to a dbf or something readable.

Will your code do this?

Thanks

 

[bobalston]

It can extract Lotus Notes data and load into Access database tables. to customize it to meet your needs you will need to know Access VBA.

If you want the code, email me at the email listed above.

bob

 

[b3llizzi]

Thanks Bob!,

Ill do that and if i'm in need of any code i'll let you know.

Appreciate the fast response.