Thursday, August 23, 2007

But What About Excel 2007?

That last post on loading multiple Excel files is probably going to be less useful if you have files in the new Excel 2007 XSLX file format. The built-in Excel source component in SSIS only works with the "classic"[1] XLS file format. Fortunately, Microsoft has made available for download a set of 2007 Office System Driver: Data Connectivity Components that allow you to connect to XSLX files via OLE DB or ODBC.

There's also a good article on this on the ssis.wik.is web site, with a few more details than you'll find on the download page.

Enjoy!

[1] I think that "classic" has a much nicer ring to it than "legacy"[2]
[2] Which was, of course, the new "old"[3]
[2] Which was, of course, the old "old"

No comments: