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

#11 Ken Blake
March 14th, 2012 - 10:09 am ET | Report spam
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.
Replies Reply to this message
#12 choro
March 14th, 2012 - 10:18 am ET | Report spam
On 14/03/2012 15:09, Ken Blake wrote:
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.




Kama? How much? It costs an arm and a leg.
Replies Reply to this message
#13 Ken Blake
March 14th, 2012 - 10:46 am ET | Report spam
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, 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.


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.
Replies Reply to this message
#14 Gene Wirchenko
March 14th, 2012 - 10:51 am ET | Report spam
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
Replies Reply to this message
#15 Peter Jason
March 14th, 2012 - 03:55 pm ET | Report spam
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.
Replies Reply to this message
Help Create a new topicNext page Previous pageReplies Make a reply
Search Make your own search