Copying filenames into a table
Thread Starter
Join Date: May 2002
Location: Green and pleasant land
Posts: 658
Likes: 0
Received 0 Likes
on
0 Posts
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
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).
Join Date: Mar 2001
Location: North Cornwall
Age: 73
Posts: 428
Likes: 0
Received 0 Likes
on
0 Posts
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
