Creating a CSV/Word file from disk directory 1

[deevaetodin]

Is there a way so that I can create a delimted file from a disk directory.

What I want to do is catalogue several hundred data disks whereby I only have their subsequent directory for file content reference.

Can I cut and paste a directory into an excel or word file. Excel would be preferred as it will end up in an Access table.

Any help would greatly be appreciated.

 

[Dreamboat]

Exit to a dos prompt.

C:\>

Using DOS commands, go to the folder you're wanting to get.

cd mydire~1 (where the foldername is mydirectory and has more than 8 letters)

At that prompt:

C:\mydire~1>

Type the following:

prn dir /s ltp1:

and hit enter. It means print this directory with all subdirectories to lpt1 (your printer).

I'm pretty sure that's the right syntax. Here's what it's based on:

PRINT [/Bbuffersize)] [/Ddevice)] [/Mmaxtick)] [/Qvalue] [/Stimeslice)][/Ubusytick)] [/C][/P][/T] [d:][path][filename] [...]

I'm sure someone will correct my syntax if it's wrong!

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com

 

[Hasit]

I do not know whether what Dreamboat suggests is correct, but you could try this:

1. Exit to DOS (command)
2. Type the following form which ever directory you want to catalogue:

dir /s > FILENAME.txt

3. This will perform a directory listing (including sub directories) and put the contents into the file you specify.

4. In Excel, open the txt file you created and follow the prompts to translate a text file into something Excel can understand. You can either use "delimited" or "fixed width" structures. The top of each page printed by the "dir /s" command is a mess, which you will probably want to delete, but the rest of it is the directory listing.

 

[Dreamboat]

Thanks, Hasit. Just realized I completely ignored the csv part.

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com

 

[deevaetodin]

That's great guys.

I figured I would need to do a little clean up but it this saves a tonne of data entry.

Thanks.