Prev: Using sp result of SELECT
Next: How to Exec Stored Proc Param from Flat File
From: SnapDive on 28 Apr 2010 19:44

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. :)

Thanks.


 | 
Pages: 1
Prev: Using sp result of SELECT
Next: How to Exec Stored Proc Param from Flat File