Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Creating a report of harddrive content excel?

Thread Tools
 
Search this Thread
 
Old 08 July 2003, 06:11 PM
  #1  
philgr
Scooby Regular
Thread Starter
 
philgr's Avatar
 
Join Date: Jun 2000
Location: Cumbria
Posts: 606
Likes: 0
Received 0 Likes on 0 Posts
Post

Does anyone know if there is a way of creating a report of files that are held in folder on your harddrive,

I have a rather large music collection on a spare harddrive which are filed by artist and album and i would like to create a report in excel or the like,

Advice Please, there must be a way of doing this.

Thanks
Phil G
Old 08 July 2003, 07:11 PM
  #2  
R1916v
Scooby Regular
 
R1916v's Avatar
 
Join Date: May 2002
Posts: 1,002
Likes: 0
Received 0 Likes on 0 Posts
Post

hmm had to think of a way to do something like this at work the other day.

open a command promt and do a dir /? to see what switches youd need to use

then do a dir *. "whatever switches you want" > C:/list.txt

Thatll get everythign from a dir into a text file wherever you want it, just change the last bit to what you want.

Dunno if this will help tho.

Old 08 July 2003, 09:00 PM
  #3  
Fosters
Scooby Regular
 
Fosters's Avatar
 
Join Date: Jul 2000
Location: Islington
Posts: 2,145
Likes: 0
Received 0 Likes on 0 Posts
Post

dos
tree /f
dir *.* /s

treeview pro probably outputs to a file
Old 09 July 2003, 08:18 PM
  #4  
philgr
Scooby Regular
Thread Starter
 
philgr's Avatar
 
Join Date: Jun 2000
Location: Cumbria
Posts: 606
Likes: 0
Received 0 Likes on 0 Posts
Post

Cheer's Guys

Never thought i would be back at the dos stuff again,

I have now got a full drive inventory into excel and im sorting it out !!

Phil G
Old 09 July 2003, 08:27 PM
  #5  
Big Goon
Scooby Regular
 
Big Goon's Avatar
 
Join Date: Apr 2002
Posts: 1,404
Likes: 0
Received 0 Likes on 0 Posts
Post

http://homepages.nildram.co.uk/~swel...T00nz-2003.htm


Are you looking for something more like this ?



[Edited by Big Goon - 7/9/2003 8:30:32 PM]
Old 10 July 2003, 10:36 AM
  #6  
Rusty Festa
Scooby Regular
 
Rusty Festa's Avatar
 
Join Date: Jun 2002
Location: Didcot, South Oxfordshire
Posts: 1,999
Likes: 0
Received 0 Likes on 0 Posts
Talking

Just tried this with sucess

c:>tree/F >filename.doc

the F switch needs to be capital F and it outputs to a file called filename.doc (feel free to change filename and/or extension) to your C drive
Old 10 July 2003, 04:05 PM
  #7  
chockymonster
Scooby Regular
 
chockymonster's Avatar
 
Join Date: Aug 2002
Posts: 577
Likes: 0
Received 0 Likes on 0 Posts
Post

Have just the thing for you,

Drop me a mail and I'll point you in the right direction.
Old 13 July 2003, 12:17 PM
  #8  
philgr
Scooby Regular
Thread Starter
 
philgr's Avatar
 
Join Date: Jun 2000
Location: Cumbria
Posts: 606
Likes: 0
Received 0 Likes on 0 Posts
Post

chockymonster YHM
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Sam Witwicky
Engine Management and ECU Remapping
17
13 November 2015 10:49 AM



Quick Reply: Creating a report of harddrive content excel?



All times are GMT +1. The time now is 02:36 AM.