Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 377
  • Last Modified:

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

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
awehme
Asked:
awehme
  • 3
  • 2
2 Solutions
 
Gary DewrellSenior Network AdministratorCommented:
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
 
tosh9iiiCommented:
Could you elaborate a little on the "lookup tables"?

But for now see if this does any good:
http://camalotdesigns.com/software/xfl/
0
 
Gary DewrellSenior Network AdministratorCommented:
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
Technology Partners: 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!

 
awehmeAuthor Commented:
Thanks guys.

gdewrell is what i was looking for

Tosh9iii....cool I didn't know that was out there
0
 
awehmeAuthor Commented:
Is there also a way to get the attrib's to the files.  ie. Date, time, size ??
0
 
awehmeAuthor Commented:
found it.  It's Just Dir > files.txt
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now