Your stated problem does not require that you open multiple files for reading at the same time.
Your stated problem was to cycle through all text files in a folder, find out how many records (lines) there are in each file, then write the result to a log (SQL or Access table). If that is not your objective restate it.