![]() ![]() 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. |