>To make our application work with Excel 2007 the IMPORT command doesn't work anymore and reading MS article
http://support.microsoft.com/default.aspx?scid=kb;en-us;949529 we want to go with the ODBC route and the SQLEXEC but the article states to download "The 2007 Office System Driver: Data Connectivity Components package" I've never downloaded that and the Excel driver works for me. Does this get installed with Office 2007 by default or do I need to make this a prerequisite for our application if you want to use Office 2007?
Drivers get installed by Excel installation and you can also install on demand. I use OLEDB drivers and happy with it. Maybe you should prefer over ODBC connection too. Check this if you want:
http://www.foxite.com/archives/0000153776.htmCetin