Matt,

Read my post, above. Basically, a spreadsheet is like a database, and a worksheet is like a table. With an Excel connection in SSIS, you can pretty much do anything with an Excel spreadsheet that you can do with a database. You don't need to access the Excel object model.

pss