Creating a list of filenames from Explorer to Excel??? 1

[wicsteve]

Is there a easy method for copying a list of filenames from within Explorer and inserting them into Excel or Access? I want to create a database of filenames that are on my computer.

 

[gpalmer711]

Not really an easy way to get them in a format that be easily read. You can output the DIR command to an excel file.

Click Start >> Click Run >> Type CMD >> Click OK >> Type C: press return >>type cd\ press return >> Type "dir /s > files.xls" (without quotes) Press return

File c:\files.xls will now contain a list of all files and folders. However it is probably not what you want.

Greg Palmer
Free Software for Adminstrators

http://www.palmersoft.co.uk

 

[Rick998]

wicsteve

See if the freeware utility Dir2HTML (

http://www.pc-tools.net/win32/freeware/dir2html/)

gives you the results you want.

Set it to 'recursive' then open the resulting HTML file in Excel.

Hope this helps...

Rick

 

[Madawc]

It should be easier to do it via Word. Get it into a neat table within Word, which is much better at editing. Depending on what you want, a table in Word might be enough.

Madawc Williams (East Anglia)