Taking a nod from Captain Wrong's SuperGun journal, I decided to create a database for my collection, and put it online, while posting my progress for others who are interested in it.
The decision came when my webhost, www.powweb.com decided to allow people to open MySQL databases at no charge. The first thing I did when this happened was updated my website, www.kindstranger.com with a php news engine. This will be my reference material for generating calls and webpages once my collection database is online.
The second thing I needed to do was decide on a database program for my collection. Cart Commander was a good program, but MS Access seemed to have the most import/export capabilities, not to mention infinite customability. I decided on MS Access, and this turned out to be an excellent choice.
I'm not very familiar with Access, but it's pretty user friendly (for a dB program anyways), and I was able to make a couple of tables for games, systems, and peripherals, and forms for inputting data and looking through my collection when I'm at home. Here is a pic of the dB after an hour or so:
http://www.kindstranger.com/Images/vgdb.png
Here's one after I entered some test data and added another table and another form. This is pretty much how it will look from this point on, except I need to add a form for peripherals:
http://www.kindstranger.com/Images/vgdb2.png
I spent a couple hours trying different export options for generating text files, excel documents, xml, etc. to import onto my SQL database, What finally worked was a combination of ODBC and a program called MySQL-Front. MySQL-Front understood ODBC, and allowed me to import my entire .mdb file without issue.
Now, I've got two main goals. First, I need to learn enough PhP to be able to create pages that will allow me to access my collection data online. Second, I need to populate the tables with data. In other words, I need to type in all my games/system/peripherals
After that is done, I'll make a trade list which will be connected to the main collection db, and will automatically update both databases whenever I add or detract from my collection or trade list. Finally, I'll make a webpage where people can look at my trade list, and search through it by system, game, rarity, etc. Whew!