Turn a music folder into a Database?

[Guest]

I've ripped all of my CDs to my hard drive. Is there any quick way I can use
that music folder with all of the music files to make a database of all the
artists, albums, and songs?

 

[Joseph Meehan]

I've ripped all of my CDs to my hard drive. Is there any quick way I
can use that music folder with all of the music files to make a
database of all the artists, albums, and songs?

Unless you are ready to type in all that information, I suggest you
google around and see if you can find a caned database that has or will
allow you to link on-line to fill in all the artist and songs information
from the album etc.

Access will do it and you can have a very nice final product, but Access
does not have any package of the information.

 

[Guest]

I understand that their are programs out there that can automatically sort
whats on your hard drive for music files .mp3, .wav etc.... I am wondering if
access can just import the files based as .mp3 or .wav and just take that
information and show up a list. Basically I don't want to manually type
in the information. I just want to import all the files into a database that
will automatically give me a list. Is that possible to do with access??

 

[Douglas J. Steele]

Yes, it's possible, and I've actually written about how to do it in Access
Advisor (the June, 2005 issue, to be precise). Unfortunately, the terms of
my contract with Access Advisor doesn't let me reproduce my articles onto my
website, the way I could with Smart Access. I'm working on having Access
Advisor make all of my old articles public, so keep checking
http://my.advisor.com/articles.nsf/aid/16430 to see whether they've done it
yet. Related columns are http://my.advisor.com/articles.nsf/aid/14849 and
http://my.advisor.com/articles.nsf/aid/16279 (this last one is public
already)

One option would be to take the information in the 3rd link above
(http://my.advisor.com/articles.nsf/aid/16279) and combine it with the
information in my November, 2004 "Access Answers" column in Pinnacle
Publication's "Smart Access" (available for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html)

Another relatively easy option is to put all of the songs into Microsoft's
Window Media Player. You can then extract the information from there and
store it in Access. There's extensive information about the Object Model for
WMP at http://msdn2.microsoft.com/en-us/library/aa393405.aspx and a good
introduction (albeit using VBScript and not VBA) at
http://www.microsoft.com/technet/scriptcenter/funzone/player.mspx

 

[Guest]

Thanks Doug, the articles were definitely helpful. I am not entirely versed
in VB script let alone the programming of If statements and etc. in Access. I
am going to have to go about learning some more to do the MP3 database. It
looks super detailed and useful. I like the way it sounds. Any suggestions on
how I can have a better grasp to programming the database? I would really
like to get started on it. Thanks again

 

[Douglas J. Steele]

You might take a look at some of the Tutorial references Jeff Conrad has at
http://www.accessmvp.com/JConrad/accessjunkie/resources.html#Tutorial