[thelist] Exporting Lotus Domino database to MS Access

[ashok at magicalkenya.com]

Minh Lee:

Try the following method , it worked for me...
Create a view  in your domino database having the same structure as your
access table.
Open the view in Notes Client and export (File->Export) and select format
as Lotus 123.
Open the lotus 123 file in excel and save it as xls.
You can very easily import the xls into access using the import
functioanlity of access....

Another way could be to use the NotesSQL driver and use that to connect to
the notes db from access using ODBC as the import source.., (All the views
will appear as tables )

HTH
ashok

---------------------------------------------------------
From: Minh Lee Goon <v7ac at sdsumus.sdstate.edu>
To: evolt <thelist at lists.evolt.org>
Subject: [thelist] Exporting Lotus Domino database to MS Access
Reply-To: thelist at lists.evolt.org

evolt,
Has anyone had any experience migrating a Lotus Domino database to an
Access format? Or at least found any documentation that would help me
out? Thanks in advance.

Minh Lee Goon