![]() select * from OPENROWSET('.12.0', 'Excel 12.0 HDR=YES DATABASE=D:\test.xlsx', sheet1$) ![]() sp_MSset_oledb_prop N'.12.0', N'DynamicParameters', 1Ĥ- Don’t use ‘select * from sheet1$’ in OPENROWSET function. sp_MSset_oledb_prop N'.12.0', N'AllowInProcess', 1ĮXEC master. ![]() If you don’t run it as an administrator account you will have this error (Cannot initialize the data source object of OLE DB provider ".12.0" for linked server "(null)".ģ- Run this command to configure your Database EXEC sp_configure 'show advanced options', 1 ĮXEC sp_configure 'Ad Hoc Distributed Queries', 1 ĮXEC master. To run OPENROWSET in 64 bit version of windows.ġ- Install AccessDatabaseEngine_圆4.exe (Restart is required).Ģ- If you are using SQL Management Studio, run Management Studio as administrator.
0 Comments
Leave a Reply. |