Solved

List of file names in a folder in .txt or xls file

Posted on 2004-08-20
6
371 Views
Last Modified: 2010-04-03
At work we have about 2,000 files of .rpt files ( report files ) in a folder on a server.  I want to be able to place those 2,000 filenames in a format that I can put in Excel and run lookup tables on.  Can this be done.??

Thanks
0
Comment
Question by:awehme
  • 3
  • 2
6 Comments
 
LVL 12

Accepted Solution

by:
Gary Dewrell earned 400 total points
ID: 11857382
Hi awehme,
I can tell you a low tech way that works.

from a dos prompt in the directory issue this command:  dir /B > files.txt
then load Excel and open files.txt  It will import the file names into excel.


God Bless
0
 
LVL 9

Assisted Solution

by:tosh9iii
tosh9iii earned 100 total points
ID: 11857384
Could you elaborate a little on the "lookup tables"?

But for now see if this does any good:
http://camalotdesigns.com/software/xfl/
0
 
LVL 12

Expert Comment

by:Gary Dewrell
ID: 11857393
What I gave you simply gets the names into excel. Once you have them into excel you can do what ever other functions you want to do.  Here is a step by step article on how to use lookup tables.

http://www.glencoe.com/ps/computered/pas/article.php4?articleId=411
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 2

Author Comment

by:awehme
ID: 11857398
Thanks guys.

gdewrell is what i was looking for

Tosh9iii....cool I didn't know that was out there
0
 
LVL 2

Author Comment

by:awehme
ID: 11857587
Is there also a way to get the attrib's to the files.  ie. Date, time, size ??
0
 
LVL 2

Author Comment

by:awehme
ID: 11857612
found it.  It's Just Dir > files.txt
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I previously wrote an article addressing the use of UBCD4WIN and SARDU. All are great, but I have always been an advocate of SARDU. Recently it was suggested that I go back and take a look at Easy2Boot in comparison.
Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question