Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Script to consolidate a few thousand .txt files in to one excel sp
1 view
Skip to first unread message
Trahsub
Dec 23, 2009, 10:02:01 AM12/23/09
to
Anyone have a script that will look at about 3000 .txt files located in one
directory, and write the contents of each file in to a single excel
spreadsheet?
directory, and write the contents of each file in to a single excel
spreadsheet?
Pegasus [MVP]
Dec 23, 2009, 1:16:01 PM12/23/09
to
"Trahsub" <Tra...@discussions.microsoft.com> said this in news item
news:5982969C-57A1-4E7F...@microsoft.com...
It depends a lot on the structure of the text files and what you expect in
your spreadsheet. The simplest solution is a console command:
copy "d:\My Files\*.txt" d:\Combined.xls
0 new messages