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

#16 J. P. Gilliver (John)
March 14th, 2012 - 05:40 pm ET | Report spam
In message <jjq0k9$1ob$, Ken Springer
writes:
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.


[]
Horses for courses. Spreadsheets are ideal for some things, especially
if they involve calculations. Databases are good for what they're good
for - linked lists in one form or another. One thing spreadsheets should
_not_ be the first choice for are tables: too many people, when they
want a table, immediately think of a spreadsheet, even to the extent
that they sometimes say spreadsheet when they _mean_ table. Within
Office, at least, the table functionality of Word is far better than
that of Excel. Spreadsheets _only_ when you need _calculations_ - i. e.
_not_ for grids of _text_.
J. P. Gilliver. UMRA: 1960/<1985 MB++G.5AL-IS-P--Ch++(p)+Sh0!:`)DNAf

Every time I think I know where it's at, they move it.
Replies Reply to this message
#17 Bob I
March 14th, 2012 - 06:17 pm ET | Report spam
On 3/14/2012 10:46 AM, Ken Blake wrote:
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.




Ken, I think it depends on whether you have a ready supply of arms and
legs or not.
Replies Reply to this message
#18 z
March 14th, 2012 - 10:31 pm ET | Report spam
In article ,
says...

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.



I totally agree. I have been using Access since Access 1.1
It was a bit buggy back then, but since Access 2 it has been great.
If you have programming skills, you can get Access to do just about
anything.

The only weakness is doing graphs, and that is easy to fix, just link
Excell to the database and create the graphs in excell.
Replies Reply to this message
#19 Gene E. Bloch
March 15th, 2012 - 08:05 pm ET | Report spam
On 3/14/2012, z posted:
In article ,
says...

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.



I totally agree. I have been using Access since Access 1.1
It was a bit buggy back then, but since Access 2 it has been great.
If you have programming skills, you can get Access to do just about
anything.

The only weakness is doing graphs, and that is easy to fix, just link
Excell to the database and create the graphs in excell.



There's a great (well, somewhat funny) poem by Ogden Nash about the
one-L lama, the two-L llama, and a punchline which I won't spoil.

Gene E. Bloch (Stumbling Bloch)
Replies Reply to this message
#20 Peter Jason
March 15th, 2012 - 08:10 pm ET | Report spam
On Thu, 15 Mar 2012 14:31:01 +1100, z wrote:

In article ,
says...

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.



I totally agree. I have been using Access since Access 1.1
It was a bit buggy back then, but since Access 2 it has been great.
If you have programming skills, you can get Access to do just about
anything.

The only weakness is doing graphs, and that is easy to fix, just link
Excell to the database and create the graphs in excell.



I was advised to use "MsGraph" for charts etc. so that Excel is not
required. This works fine for bar charts etc and are based on
Queries (including Xtab queries.)

http://support.microsoft.com/kb/186855

I started with Access97 and the charts are all working OK in
Access2010.

I never figured out how to use the Excel thing.

Replies Reply to this message
Help Create a new topicNext page Previous pageReplies Make a reply
Search Make your own search