[taggs]

Hi there,
I want to list all my music files in a database and/or spreadsheet. All of the files and folders are in one main mp3 folder. Does anyone know of a way that I can extract the files to list in an application such as Access or Excel?

For example

I have, say, a file structure like: MP3 (FOLDER) --> ARTIST NAME (FOLDER) --> ALBUM NAME (FOLDER) --> SONG TITLE (FILENAME)

The application would extract these files into a database or table like:

ARTIST NAME.......... ALBUM NAME............SONG TITLE
Billy Ray Cyrus.........Achy Breaky Heart....Achy Breaky Heart*
Britney Spears.........In The Zone ........... Toxic*

etc etc etc

There's maybe a really simple way to do this through Windows XP, but anyway, all suggestions appreciated

* Note: Songs listed are for illustration purposes only. They are not, nor should ever inferred to be, in the music collection (mp3 or otherwise) of the author of this post.

[Advertisements]

did some searching and came up with this: http://www.softpedia...t-Creator.shtml

[starjax]

did some searching and came up with this: http://www.softpedia...t-Creator.shtml

[dsenette]

http://www.freedownl...ee_Printer.html
this one won't do what you want DIRECTLY...but with a little tweaking it will allow you to grab what you want out of it....it will create a text file that has the file trees listed...

if you change the "output settings" to tree view instead of list view... you get something like this:

C:\<foldername>\
|
|___<Subfoldername>
|
|___<FileList>

so in your case it would be like

C:\<music>\
|
|___<Billy Rae Cyrus>
|
|___<Achey Breaky Heart(album)>
|
|___<Achey Breaky Heart(Song)>
<Whatever other songs this loser sang that no one listened to>



and it would do that for each folder that's within the main <music> folder...
you could then copy each section to the proper column in a exell file

though this might get hairy...i'll keep looking hehe

[taggs]

Sorry it's taken so long to reply, been rather busy. Two good suggestions - I will try them both and let you know how it goes.

<Edit> --------------

Just discovred Directory Lister at http://home.autocom....e/index_en.html

I'll try this. It doesn't do exactly what I want but I'll give it a try.

Thanks again.

Cheers.

Edited by taggs, 28 June 2007 - 05:55 PM.