I need to export all Data in one of our current Databases into a MS Excel or Access DB. The data will then be imported into a non-notes database. The Notes application uses several response documents with data that needs to be linked together for use in a new non-notes UI. I have never done this before and was wondering how would be the best way. Any Ideas appreciated.
Subject: Try this tool: A.N.D.I. at http://bpjl.netfirms.com
It’s a nice tool for exporting or importing data with Lotus Notes.
You can import or export to Access or any other database using ODBC
Subject: Export Data to be used in SQl Database
I know there are templates in the sandbox section of this site that integrate Notes with Excel. This will make it easy to get the data out of notes without building a large # of views. You can create a seperate “tables” for each notes form. Create keys to link your records as needed.
If you are doing this just once, try creating a view with all the fields you need from a given form, and just do file-export. Lotus 1-2-3 has issues with the number of rows exported. If you go this route, you may need to do “X” documents at a time.
Subject: RE: Export Data to be used in SQl Database
I have created a large view and it works well as an export to Lotus 123. It is the linking of the data on the response documents that has me concerned. I will try the link you supplied. Thanks much!