how do i create an album folder library

gamston

hi all
been looking round for an easy way to create a library of all my mp3 albums, i've got 50+ dvds with mps albums on them, so about 1000 albums
what i'm looking for is something easy, i want to let my daughter make the library while she is on school hols
what i want is to put dvd in drive, put up the album/folder names(not worried about each track on the album) then put my dvd ref no in list, then put in next dvd,
all i want is a basic list like below

AlbumDVD Nobeatles hard days night1beatles sgt pepper6beatles white album5

M4RKM

What are you wanting? Are you wanting just an excel spreadsheet with what's on each disc? Is that what you want?

Or are you wanting to drag these off the DVD's and have a structured library within windows folders.

M

gamston

looking for a simple spreadsheet/database,
but want it to automaticly pick up the albums/folder names then i just add the cd/dvd ref no

M4RKM

I did a quick google, and found this elsewhere, which seems feasible enough..

Maybe use dir command?

Open command prompt
Change to the folder you want to list (so if CD drive is letter D you will type
Type "dir > C:\files.txt" (don't include the " and i'm assuming you have to put in a path/drive letter, as you can't create the listing on a nonwriteable drive like cd..

Open the files.txt in Notepad.exe, delete header and footer information, and all directory entries so it only shows files, save it.
Open Excel, go to File --> Open, change Files of Type to Text Files
Browse to the files.txt file and select Open
Follow the onscreen instructions for fixed width data type, lines breaks, etc...

Rinse and repeat.

Hope that works/helps

M