Can't seem to figure out how to save this html table as an excel file or csv. My preference is to be able to write it directly to a MySQL table using ColdFusion but can't figure out how to do that either because the html table is just an output of a complex set of queries that include summary calculations, etc. I am ultimately trying to consolidate a MySQL table that has nearly 100,000 rows into a new table that calculates and summarizes the overall rows into a summary table like this page.
I intend to simply import the excel or csv to my MySQL database as a new table using PHPMyAdmin's import tool. I hate that I need this extra step, but I am not a good enough coldfusion programmer to know how to build an array, etc. It's just too complex for my experience. So this is my possible workaround.