WayneS (10/10/2010)
Well, SSIS does use the Jet driver, via OpenRowSet, to work with Excel files. So, this link will probably help you out. You would just need to add it to the extended properties of the Excel Configuration in the properties window.
Wayne, what is a better approach of the two
1. SSIS Excel Com Components
OR
2. Implementing a .NET API (I vote for .NET API)
Raunak J