Text Files

[rpeare]

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.

[Wasp1]

Yes....I still need 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 (Access table - tblData).

My Point that I'm trying to make: My code Error at Set f = fs.OpenTextFile. (The error message is 450 Wrong number of arguments or invalid property assigned). How can I set F ?

[rpeare]

If your stated goal hasn't changed why are you trying to open multiple files with a single line of code (other than it's impossible)?

Think about how you would do this if you had 100 pieces of paper and each piece of paper had a random number of lines on it.

You wouldn't spread the 100 pieces of paper on the ground and try to count all the lines on every sheet of paper at the same time.

You'd look at the first sheet of paper, count the lines on it, then move to the next piece of paper and repeat the process. You are going to follow the same methodology in your code.

Open Text file 1, count the number of rows, close text file 1, write the line count, file name, size, etc, to a log.
Open Text File 2, count the number of rows, close text file 2, write the line count, file name, size, etc, to a log....

continue for as many files as you have.

[casinc815]

Wasp1:

You question on how to account for multiple textfiles is already accounted for in the
loop before the insert statement. If you want to loop through multiple files and count
the records in each file that is a loop within a loop!!! You are looping through the textfile
list in the direct and then looping through each text file to count the records.

Good luck!