From: SnapDive on

I have some many Excel 2007 files with several thousand rows. I only
need one column from each .xlsx file to get into a SQL Server 20008
table.. Since the .xlsx filetype is XML, I thought it would be cool to
bring each .xlsx file into a temporary table, shred it using an XML
query (or XML-index it even on value), and then insert the result into
a real table.

I am having a hard time finding anything about the .xlsx file format
to even try things. If anyone has any sample (pseudo) code or ideas,
I'm all ears. :)