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.
http://www-10.lotus.com/ldd/sandbox.nsf/ecc552f1ab6e46e4852568a90055c4cd/f1c6d131359bc0618525696c004b29b2?OpenDocument&Highlight=0,Excel
Return to top
. . RE: Export Data to be used in SQl D... (~Mark Xanponete... 5.Feb.03) 
Print this page
