I have a stored procedure in sql server 2005 (running on win server 2003) that uses Microsoft.Jet.OLEDB.4.0 to import an excel file. It works brilliantly... for xls file. To import the newer xlsx format files I believe that I need to use Microsoft.ACE.OLEDB.12.0. The problem is that, even though I have office 2007 (with access 2007) installed on this machine, I don't think I have that provider (there is no registry path anywhere under HKLM\software\microsoft\microsoft sql server that contains a key referencing Microsoft.Ace.OLEDB.
1. How can I verify for sure that I do not have this provider installed?
2. Is it safe to download (from MS) the "2007 Office System Driver: Data Connectivity Components" which contains "Microsoft Office Access database engine 2007" and install it on a server that already has sql server 2005 and office 2007 (I don't want to overwrite anything that will gimp things up)?