For anyone interested, here is a little program that I threw together that can be used to help port the CPG Excel file into a database like Access. After using Excel to save your CPG Excel file as a Tab Delimited Text File, this conversion program can be used to "flatten" the tab delimited text file and convert it into a pipe delimited text file that can easily be imported into databases. You can download it for free here:

http://www.markosoft.net/downloads/excelcnv.zip

The resulting data looks like this:

Marvel|AVENGERS Volume 1 (1963-1996)|1|Poor|1|80.00|80.00||
Marvel|AVENGERS Volume 1 (1963-1996)|9|Good|1|15.00|15.00||
Marvel|AVENGERS Volume 1 (1963-1996)|13|Good|1|9.00|9.00||
Marvel|AVENGERS Volume 1 (1963-1996)|20|Good|1|5.00|5.00||

In this format it is very easy to open Access (or other databases) and import the resulting pipe demlited text file.

I also removed any character formatting (i.e. $) from the price and value fields so that these fields could be purely numeric and could be both sorted numerically and aggregated numerically in the database.

I just tested the program against a substantionally larger number of comics and publishers than I did during my initial testing and it seemed to work fine.

Please let me know if anyone finds any bugs and I will fix them.

Have a great day!

Mark