Solved

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

Posted on 2004-08-20
6
370 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Having issues meeting security compliance criteria because of those pesky USB drives? Then I can help you! This article will explain how to disable USB Mass Storage devices in Windows Server 2008 R2.
Concerto Cloud Services, a provider of fully managed private, public and hybrid cloud solutions, announced today it was named to the 20 Coolest Cloud Infrastructure Vendors Of The 2017 Cloud  (http://www.concertocloud.com/about/in-the-news/2017/02/0…
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
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…

777 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