Free program to convert CPG Excel file to database friendly format...

HOGvol — Sun, 25 May 2008 11:50:31 GMT

I previously posted this on the "Questions About CPG" board, but it occurred to me that it should probably be posted here.

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

The ComicsPriceGuide.com Boards / Comic Collecting / General Comic Discussion / Free program to convert CPG Excel file to database friendly format... / Latest Posts

Free program to convert CPG Excel file to database friendly format...