Hello,
Can someone please let me know the best way to export about 150, 000 documents.
Excel can hold about 65,000 docs. Is it the best way to export to Access or any other source to export the documents?
Thanks
sri
Subject: What is the best way to export a large view?
Depends on what you mean by ‘best’.
You could export a csv and then import into Access.
You could write code to push the data directly into Access (don’t ask, search here and the 4/5 forum for code first).
You could read the data in Access by setting Notes up as an ODBC data source.
I don’t work too much with DECs stuff but I think you may be able to set up a dynamic link to Access and push the data over (really not sure on this one, but it’s worth a look - maybe visit the Enterprise Integration forum and poke around).
All of these are ‘best’ at something.
HTH
Doug
Subject: What is the best way to export a large view?
It all depends on what you want to do. While excel only supports the 65k in a worksheet, the excel in the sandbox can export over 1,000,000 documents to a workbook, it just keeps adding worksheets until all the documents have been processed.
john