How do I make a text listing of folder contents?

March 11th, 2012 - 04:55 pm ET by Peter Jason | Report spam
I have Win7 SP1.

I have a 1TB HDD now full of downloaded TV movies.

There are over 250 movies.

I want to make a list of these for my movie database and this will
involve importing the titles into Access2010.

How do I convert the titles in the right side of Windows Explorer into
a text list that can be imported into Access?

Peter
email Follow the discussionReplies 37 repliesReplies Make a reply

Similar topics

Replies

#36 Peter Jason
March 27th, 2012 - 08:36 pm ET | Report spam
On Tue, 27 Mar 2012 18:02:05 +0100, Philip Herlihy
wrote:

In article <jkfo97$s43$, says...

If you click the start button and type CMD in what I call the run box, you
will be presented with the command screen. When I do that it is a black
square window with white letters. Old timers would refer to this as the DOS
prompt but don't do that round here because they are a bit snooty. They
will even get snooty about that comment. But that will mostly be because
they did not think of what I am going to tell you. . Only joking mates.

Now you can use windows in command mode. It is exceptionally useful. In
this case for example you can use the CD command to set the default
directory to what you want.

Then you can type DIR to show a lisring of all the files in the current
directory.

I'm getting there.

Now you can also send the output of the DIR command to a file, using >

Like this:

DIR > myfile.dat

This will put the directory listing into the specified file.

Now type exit. The window will vanish. Use Notepad to read in the file and
edit it a little to remove junk. An Access user will now be able to read
that file into Access (or in fact anything you like) with ease.

Now a little lecture: In general, always remember that in Windows you can
do anything you want very easily as long as you know how, and if you think
that you really can not do what you want using the GUI, instead get out to
the command prompt and force Windows to do it with commands.



That's certainly the way I'd do this (using DIR /B), but I've just tried
out the Snagit utility from Techsmith and I've discovered it's really
good at doing this.

Snagit (like its free younger brother Jing) is a 'screenshot' capture
utility. It can grab still screenshots, or video, and can edit stills
with all sorts of agreeable fancy effects.

Snagit also has a 'text' mode, in which you draw out a rectangle to
process, and then it performs Optical Character Recognition ("OCR") and
invites you to save the results as editable text. Neat!



I have been using the Win7 "Snipit", mainly for labeling DVDs, though
the OCR seems a good idea.
Replies Reply to this message
#37 binaryman
February 28th, 2013 - 01:26 pm ET | Report spam
Peter Jason wrote on 03/11/2012 16:55 ET :
I have Win7 SP1.

I have a 1TB HDD now full of downloaded TV movies.

There are over 250 movies.

I want to make a list of these for my movie database and this will
involve importing the titles into Access2010.

How do I convert the titles in the right side of Windows Explorer into
a text list that can be imported into Access?

Peter


You should try Directory Report
http://www.file-utilities.com
It can print AVI properties
and generate reports into a .csv file which can be imported into Excel
email Follow the discussion Replies Reply to this message
Help Create a new topic Previous pageReplies Make a reply
Search Make your own search