Copying filenames into a table
Thread Starter
Joined: May 2002
Posts: 658
Likes: 0
From: Green and pleasant land
Copying filenames into a table
I'm sure this, or something like it has been asked recently but I can't find the relevant thread so apologies if this has already been covered.
It's about time I got round to sorting out all the zillions of photos and video clips I've got and to work out how to catalogue / tag them.
My smartarse other half is running Vista on her little used, leisure-use-only machine and has glibly pointed out how easy it is to tag all her photos, whereas I'm running XP on my almost-exclusively-for-business machine and have absolutely no intention of downgrading to Vista.
Does anyone know how I can copy all the filenames in any given folder and paste them as text in Word/Excel/Access, and thence add the tags I'd like to ? Ideally I'd like to include a thumbnail and/or a shortcut in the table as well but I guess that might be asking too much?
Any ideas please folks?
Thanks in advance
CS
It's about time I got round to sorting out all the zillions of photos and video clips I've got and to work out how to catalogue / tag them.
My smartarse other half is running Vista on her little used, leisure-use-only machine and has glibly pointed out how easy it is to tag all her photos, whereas I'm running XP on my almost-exclusively-for-business machine and have absolutely no intention of downgrading to Vista.
Does anyone know how I can copy all the filenames in any given folder and paste them as text in Word/Excel/Access, and thence add the tags I'd like to ? Ideally I'd like to include a thumbnail and/or a shortcut in the table as well but I guess that might be asking too much?
Any ideas please folks?
Thanks in advance
CS
Joined: Nov 1999
Posts: 428
Likes: 6
From: London
Something like Directory Lister will do it...
Print File List with Directory Lister Pro
Or just bring up a command prompt for the folder - use the DIR command to generate file list and manual copy it into excel (which should parse the columns).
Print File List with Directory Lister Pro
Or just bring up a command prompt for the folder - use the DIR command to generate file list and manual copy it into excel (which should parse the columns).
Joined: Mar 2001
Posts: 430
Likes: 0
From: South East Cornwall
Or just bring up a command prompt for the folder - use the DIR command to generate file list and manual copy it into excel (which should parse the columns).
There is a DOS command that will write the directory to a text file.
dir /b > directory.txt
this saves the cutting and pasting
This article Print a list of directory contents in Windows 2000 with DOS gives you more info and the switches you can use to alter the output.
Have fun
