Build Your Own Arcade Controls Forum

Main => Software Forum => Topic started by: slicer_d on April 20, 2004, 04:52:03 pm

Title: Anyone have an access database to play with?
Post by: slicer_d on April 20, 2004, 04:52:03 pm

Hey I was just wondering if any body has or knows where to find a access database full of mame games that I could play with so I can make my own custom quiries and reports?

Thanks

Title: Re:Anyone have an access database to play with?
Post by: jerryjanis on April 20, 2004, 05:39:20 pm

SortInfo is able to export the game and control list to a text file.  You can specify what delimeter to use, and you should be able to import that file into Access.  I have done it before with MySQL.

1) create a file with mame's listinfo with something like:
      mame -listinfo > sortinfo.txt
2) Run SortInfo.exe
3) File->Import->Mame List Info file (and select your sortinfo.txt)
4) File->Export->Argument Template File
    select the file you want to save
    enter a template.  I think that the following will save all values, separated by a '~'
     %A~%B~%C~%D~%E~%F~%G~%H~%I~%J~%K~%L~%M~%N~%O~%P~%Q~%R~%S~%T~%U~%V~%X


I was able to import this into a MySQL database.  Hopefully you can do the same with Access.  By the way, I couldn't use comma separated values because some of the data elements have commas in them.