How to export all directory detail i.e. all folder name with file name in Excel 2007

How to export all directory detail i.e. all folder name with file name in Excel 2007


I have a Hard disk that's contains 709 folder and 13546 files. Now I want to export the directory detail in excel...


Example:


D: /BABY/ DSC00002.JPG
D: /BABY/ DSC00010.JPG
D: /BABY/ DSC00012.JPG
D: /BABY/ DSC00017.JPG
D: /BABY/ DSC00020.JPG
D: /BABY/ DSC00022.JPG
D: /BABY/ DSC00025.JPG
D: /BABY/ DSC00027.JPG
D: /BABY/ DSC00029.JPG
D: /CHILD/ DSC00032.JPG
D: /CHILD/ DSC00044.JPG
D: /CHILD/ DSC00049.JPG
D: /CHILD/ DSC00052.JPG
D: /CHILD/ DSC00054.JPG
D: /CHILD/ DSC00058.JPG


Above is the example for 2 folders and its file...... & i want to export all my D: drive in excel.....

Please Help...

thanks
Dalip

1. Go to a command prompt (click Start > Run type CMD <enter>)
2. d: <enter>
3. cd\ <enter>
4. dir /s/b > list.txt

This will create a text file on the root of your D: drive called list.txt (Will probably take a long time to create it!). Open this in Excel.

You could change the field delimiters to use \ as a delimiter and then it would put each directory in a new column. Or that might just be too messy.