How do I make a text listing of folder contents?

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

On 3/11/2012 5:55 PM, Peter Jason wrote:
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

Open a CMD window on the folder (Shift right-click)
Type: DIR /B Names.txt
Edit and clean-up Names.txt
Import text file onto Database.

On 11 Mar 2012, Peter Jason wrote in
alt.windows7.general:

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?

I will make many assumptions about what it is you really want. I only
have Office 2003, so I hope it's similar to 2010. The way I'd do it is
this:

1. Open a CMD session and navigate to the folder with the movies.

2. At the prompt, type "DIR /B /ON MOVIES.TXT" (without the quotes.)
This will create a text file containing the file names.

3. Import ("Get External Data") this into Access. It might be a little
easier to copy 'n paste the contents of the text file into Excel and
save that as an XLS file. Then import the XLS into Access.

On Mon, 12 Mar 2012 08:55:43 +1100, Peter Jason wrote:

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

Thanks to all. I went to the movies HDD (K:/)
Then
K:\dirlist.txt

This generated & outputted a txt file with all the titles into the K
HDD. Now I can import this into Access10, just like my bank
statements etc.

P

Peter Jason wrote:
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
http://www.spadixbd.com/freetools/jdirprint.htm

I use this program which works nice and you do not have to remember any
coding

There's also Karen's Directory Printer, free from:
http://www.karenware.com/powertools/ptdirprn.asp

Kenny

"Smiles" wrote in message ...

Peter Jason wrote:
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
http://www.spadixbd.com/freetools/jdirprint.htm

I use this program which works nice and you do not have to remember any
coding

On 11/03/2012 23:17, Peter Jason wrote:

just like my bank statements etc.


Interesting. As a recently retired Management Accountant why on earth
would you import Bank Statements into ACCESS?

On 14/03/2012 10:06, Gordon wrote:
On 11/03/2012 23:17, Peter Jason wrote:

just like my bank statements etc.


Interesting. As a recently retired Management Accountant why on earth
would you import Bank Statements into ACCESS?

Presumably because it's the best tool for whatever he wants to do.
Nothing wrong with Access. More folk should use it instead of
always trying to do everything in Excel or other spreadsheets
(spreadsheets are perfectly designed for almost nothing, are hard
to use and prone to errors which are hard to trace.)
--
Rob

On 3/14/12 5:14 AM, Rob wrote:
Nothing wrong with Access. More folk should use it instead of
always trying to do everything in Excel or other spreadsheets
(spreadsheets are perfectly designed for almost nothing, are hard
to use and prone to errors which are hard to trace.)

Spreadsheets are intended to be used for various types of mathematical
calculations in real time, such as working out a financial plan with
future estimations of profit/loss, etc. Been there, done that with
Visicalc of many years ago. And a gazillion other types of math issues
I don't begin to know how to do.

But, I think the average user finds it easier to grasp using a
spreadsheet than a high end database like Access. And since the
majority of users don't purchase Office Pro, Enterprise, whatever, they
have no clue what Access or a database is, nor what it can do for the user.

Factor in that it's hard to find a simple to use database anymore,
especially when you can't go to a place like Best Buy, any of the big
box office supply places, and pick up a software box that is a database,
and be able to say "What's this?"

--
Ken

Mac OS X 10.6.8
Firefox 10.0.2
Thunderbird 10.0.2
LibreOffice 3.5.0 rc3

On 14/03/2012 11:51, Ken Springer wrote:
On 3/14/12 5:14 AM, Rob wrote:
Nothing wrong with Access. More folk should use it instead of
always trying to do everything in Excel or other spreadsheets
(spreadsheets are perfectly designed for almost nothing, are hard
to use and prone to errors which are hard to trace.)

Spreadsheets are intended to be used for various types of mathematical
calculations in real time, such as working out a financial plan with
future estimations of profit/loss, etc. Been there, done that with
Visicalc of many years ago. And a gazillion other types of math issues I
don't begin to know how to do.

But, I think the average user finds it easier to grasp using a
spreadsheet than a high end database like Access. And since the majority
of users don't purchase Office Pro, Enterprise, whatever, they have no
clue what Access or a database is, nor what it can do for the user.

Factor in that it's hard to find a simple to use database anymore,
especially when you can't go to a place like Best Buy, any of the big
box office supply places, and pick up a software box that is a database,
and be able to say "What's this?"


I take your point about having to buy Office pro to get Access.,
but there is always Open Office which includes Base and is free
of course.
In my experience, many ordinary folk cannot grasp how spreadsheets
work (as soon as you start talking B3, C5 etc, their eyes glaze over)
but can understand the basics of a database. After all, everyone
who has a mobile phone spit is already used to using a simple one.
Still, with all of these i-toys, soon no-one will even need (or
have the ability) to be creative or use their intelligence as it
will all be done by (locked-down) specific apps! Not a future I'm
going to be taking much part in, I may add.
--
Rob

On Wed, 14 Mar 2012 13:05:32 +0000, Rob
wrote:


I take your point about having to buy Office pro to get Access.,


A minor point, but let me mention that you do *not* have to buy Office
Professional, or any edition of Office, to get Access. Access can be
bought by itself.

On 14/03/2012 15:09, Ken Blake wrote:
On Wed, 14 Mar 2012 13:05:32 +0000,
wrote:


I take your point about having to buy Office pro to get Access.,


A minor point, but let me mention that you do *not* have to buy Office
Professional, or any edition of Office, to get Access. Access can be
bought by itself.


Kama? How much? It costs an arm and a leg.
-- choro

On Wed, 14 Mar 2012 15:18:48 +0000, choro wrote:


On 14/03/2012 15:09, Ken Blake wrote:
On Wed, 14 Mar 2012 13:05:32 +0000,
wrote:


I take your point about having to buy Office pro to get Access.,


A minor point, but let me mention that you do *not* have to buy Office
Professional, or any edition of Office, to get Access. Access can be
bought by itself.


Kama? How much? It costs an arm and a leg.



I just checked on Amazon.com. Access 2010 is $116.99 US there.

Is that an "arm and a leg"? Whether or not you think so is up to you.
I wasn't suggesting that it was a good buy; I was merely pointing out
that it's available separately--something that many people don't know.

On Wed, 14 Mar 2012 13:05:32 +0000, Rob
wrote:

[snip]

In my experience, many ordinary folk cannot grasp how spreadsheets
work (as soon as you start talking B3, C5 etc, their eyes glaze over)
but can understand the basics of a database. After all, everyone

Try a different paradigm. Ordinary folk can understand a
black/white-board.

who has a mobile phone spit is already used to using a simple one.

Using and developing are quite different.

Still, with all of these i-toys, soon no-one will even need (or
have the ability) to be creative or use their intelligence as it
will all be done by (locked-down) specific apps! Not a future I'm
going to be taking much part in, I may add.

Sincerely,

Gene Wirchenko

On Wed, 14 Mar 2012 10:06:20 +0000, Gordon
wrote:

On 11/03/2012 23:17, Peter Jason wrote:

just like my bank statements etc.


Interesting. As a recently retired Management Accountant why on earth
would you import Bank Statements into ACCESS?

Long ago I had trouble with accounting software because the
'consultants' were ephemeral, the software complex and expensive - and
unalterable, the reports meager, and when all the crying was over one
was locked in. I resolved to sack the pests and I changed over to
Access97, coming in every Sunday morning to program it. There are
tables/queries/forms and reports; all infinitely adjustable and
stable. I run my whole business on it with no regrets. Even now I
make adjustments for invoicing etc. I have never used Excel because
Access does all I need via query grids and reports. Of course the
advice I had from Access newsgroups made it all possible. Though I
had to get expert advice on a self-join query for a 4-level bill of
materials; but that was all. Thoroughly recommended.