• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Microsoft access

#1
I have converted all my music albums into MP3's . Can anyone tell me the best way to enter these in to a database using MS access. It would be too long abd monotonus job to type every thing in to it by hand . Is there a way to set it up to so that you can DRAG and DROP the info into the database.
 
M

MrFred

Guest
#2
You could use something like this to do the donkey work for you.
MP3 Collector 1.2 from h**p://www.collectorz.com/mp3/
Platform Windows 9x/ME/NT/2000/XP
FileSize 1747KB
Update 2002-04-30
Introduction: MP3 Collector is a program for organizing your personal collection of MP3 files, on harddisks, CD-ROMs, network drives, etc... You can use it to edit ID3 tags, rename files and create playlists. It also lets you create a file with detailed information about your MP3 collection. This file can be browsed, sorted and searched in various ways, even when the actual MP3 files are not available (e.g. find all MP3s with the word "love" in the title, sort your files by Genre, etc...). MP3 lists can be printed and exported to HTML or CSV files. Once exported to CSV you can the import that data to MS Access. Unlicensed copies can only be used 20 times but there are lots of other programs that can be used like this.
 
E

eNuffSaid

Guest
#3
You could dump your MP3z directory to a text file:

dir /b > songs.txt

Then import that text file into your MSAccess database (File > Get External Data > Import)

Easy as pie. :)

Kind regards,
Willem Moolenaar
 

Members online

No members online now.

Latest posts

Latest profile posts

Hello, is there anybody in there? Just nod if you can hear me ...
Xie
What a long strange trip it's been. =)

Forum statistics

Threads
61,961
Messages
673,239
Members
89,014
Latest member
sanoravies