OPENROWSET from excel 2010 and 2007
I have the below versions in my stystem: Database Version: SQL Developer Edition (64-bit) Windows Version: Windows 7 Enterprise (64-Bit) Excle: Micorsoft Excel 2010 or 2007(64-Bit) Since all the versions are 64 Bit. So we need to install Microsoft.ACE.OLEDB.12.0 from “AccessDatabaseEngine_x64”. instead of 'Microsoft.Jet.OLEDB.4.0'. We can download this from the below link http://www.microsoft.com/en-us/download/confirmation.aspx?id=13255 After downloading and running the setup. Run the below queries step by step. sp_configure 'show advanced options' , 1 GO RECONFIGURE GO sp_configure 'Ad Hoc Distributed Queries' , 1 GO RECONFIGURE ; -----Run the below query after running above. EXEC master . dbo . sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess' , 1 GO EXEC master . dbo . ...