dwain.c (1/15/2013)

---

You must have all 3 running in the same mode. The driver won't allow you to install 32 bit in a 64 bit environment.

Koen Verbeeck (1/15/2013)

---

You can install a 32-bit JET provider in a 64-bit environment. However, if you have 64-bit Office installed (which you shouldn't on a server), then you can't install the 32-bit provider or vice versa.

Koen Verbeeck (1/15/2013)

---

I think you can use the 2010 ACE OLE DB driver to read from 2007 workbooks. It's possible you'd have to change the Excel version in the connection string.

SELECT *
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 
    'Excel 12.0;HDR=NO;Database=filename.xlsx,'SELECT * FROM [Sheet1$]')

sathiyan00 (1/15/2013)

---

its showing error
Msg 7302, Level 16, State 1, Line 1
Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".