Hello Varun,
The solution you chose also depends upon characteristics of the incremental reload.
If the incremental process is a pure append, meaning all the rows loaded prior are preserved and the table will only grow and never edit, this allows certain options like Buffer to be considered in addition to EXISTS or WHERE filters.
If the incremental process involves updating or deleting prior loaded records, or originates from a SQL statement, without dates you most likely have to engage a primary key filter via an EXISTS or WHERE clause.
Even in dupe scenarios, where every field in one row is identical to one or more rows, the differentiator of appending a RecNo() should be enough to give you a consistent Autonumber() that doesn't lose track of even duplicates.
