Record Count of Flat Files

[skuppusamy]

Is there an easy way to find the number of records in a flat file (VB6) instead of opening it and keepin a counter as we read records? Any help will be appreciated.

Thanks
Siva

[Phil Weber]

If the records are fixed-length, you may divide the file length (LOF or FileLen functions) by the record length to determine the number of records. If the records are variable-length, you may read the file in chunks of, say, 64K bytes and use InStr to count the number of end-of-record markers (e.g., vbCr).

[Keithuk]

It depends on how these records are stored, one per line, then just do a line count.