Microsoft access

Discussion in 'Windows Desktop Systems' started by brocher, Nov 5, 2002.

  1. brocher

    brocher Moderator

    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.
  2. MrFred

    MrFred Guest

    You could use something like this to do the donkey work for you.
    MP3 Collector 1.2 from h**p://
    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.
  3. eNuffSaid

    eNuffSaid Guest

    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