I have been given an Excel spreadsheet (.xls format), and I need to import the table into a SQL (2000) database, which I've done with other spreadsheets in the past. The only problem with this spreadsheet is that one column is color coded with information that I need to extract. Obviously the spreadsheet was made for human eyes.



Each cell may have any one of four background colors which I need to electronically distinguish. I don't even know the "name" or value of each of the colors. They just "appear" red, dark blue, dark green, or light gray. I need to interpret the color into two bits of information (which I could call "C", "S", "both", or "neither").

This table has well over 2000 rows.

See the following page of User-Defined Color Function in Excel

http://www.cpearson.com/excel/colors.aspx