News Stay informed about the latest enterprise technology news and product updates.

How to import an unlimited number of data records into Lotus Notes

Here are step-by-step instructions for importing an unlimited amount of data records into Lotus Notes -- no programming experience required.

With the method I explained in Part 2, the limit of 65,000 records is imposed by Microsoft Excel, rather than Lotus Notes. So if you skip the Microsoft Excel step, there is effectively no limit on the number of records you can import to Lotus Notes from a .TXT file. I have tested 175,000 records.

For imports greater than 65,000 records, simply create a tab-separated .TXT file directly from your source program, and then perform the import to Lotus Notes as described in Part 2.

If your source program cannot create tab-separated output, you might try a different separator, such as vertical bar (|). Just edit the .COL file and replace <tab> with the new separator.

When you go directly from the source program to a .TXT file, you miss the opportunity to examine and clean the data with Microsoft Excel. But this may be necessary in order to perform very large imports.

You can write some simple @-function agents later within Lotus Notes to fix data problems when the import is finished. You can even put the @-functions directly into the .COL file.

For advanced tricks that you can do with a .COL file, such as @-function post-processing of imported data, see Domino Designer Help -> Index -> COL Files.


 Home: Introduction
 Part 1: How to import up to 8,000 data records into Lotus Notes
 Part 2: How to import up to 65,000 data records into Lotus Notes
 Part 3: How to import an unlimited number of data records into Lotus Notes

Chuck Connell, Consultant
Chuck Connell is president of CHC-3 Consulting, which helps organizations with all aspects of Lotus Notes and Domino.

Dig Deeper on Lotus Notes Domino Administration Tools



  • iSeries tutorials'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 ...