Hi,I am exporting some 10,000 documents which include data from about 4 forms and a total of about 50 fields to Excel using LS and this involves computations among different forms.
The problem is that this is taking too much time for my comfort.Can someone suggest a way out.
Thanx in advance.
Subject: Slow Export to Excel
could you create a ‘bridge’ database containing one view for each escel document, and one notes document for each excel row?You can populate this VERY quickly with lotusscript or even possibly @function language, then use regular File-Export on the views to create the Excel sheets
Subject: Slow Export to Excel
Not really…Only things you can really do is run on a faster computer, replica the database you are working on locally and run it locally. COM interoperability is heavy lifting and isn’t always known to be zippy, particularly with the # of docs and fields you are working with.