Problem solve Get help with specific problems with your technologies, process and projects.

Transfer docs to Excel via file transport

How we can transfer more than 10,000 docs to Excel via file export? Once I read that it is a problem of Lotus 123...But what is the alternative I can use? I have to process a lot of numbers.

In script, I am doing it but it is too slow if you cross more than 2000 docs...

Is there anything I am missing here?

Try creating an ASCII text file and use minimal processing in your loops that writes out to the file (i.e. process entire variable and use a PrintLN to output to the file instead of outputting one var at a time. Use a good separator and then open the file with Excel. Excel will automatically launch in import wizard.

Dig Deeper on Domino Resources

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...