Count Rows in all files in a directory

**dyung** · 05-09-2016, 03:47 PM

Hi experts,

I have a directory with a couple of thousand CSV files, and I need to get the number of records in each file as well as the total number of records in all the files. How can I write a VBA script to accomplish this? I have tried a script that merges all the files but this is very time consuming and often times the merged file cannot hold all the records from the source files.

Thanks in advance for your help!
Cheers,

**mikeTRON** · 05-09-2016, 05:32 PM

In the past I have used a super simple BAT file to combine the CSV files then pulled them into POWERPIVOT (although access might work as well).
I believe I had 24M rows of data before they let me have a SQL table to play in so row count shouldnt be an issue.

Simple .bat file creation:
http://stackoverflow.com/questions/2...ing-batch-file

If you wanted to go the VBA route I would absolutely use ADO.
This might get you started.
http://www.vbaexpress.com/forum/show...V-or-Text-File

Count Rows in all files in a directory

LinkBack

Thread Tools

Rate This Thread

Display

Count Rows in all files in a directory

Re: Count Rows in all files in a directory

Thread Information

Users Browsing this Thread

Similar Threads

Moving Files from one directory structure to another directory

How can i get the records/rows count of files in a directory

[SOLVED] Macro to Import Multiple TXT Files into workbook - User to select files/directory

How to count # of .xls files in a directory - I NEED HELP PLEASE

Macro to Move files from one directory to other directory

Program to open and append all files in a given directory......not work at ~ 92k rows

Reading in the files in a directory into an array, directory chosen by user

Count files in directory

Bookmarks

Bookmarks

Posting Permissions