This is an untouched official ISO image of Microsoft Office 2013 professional plus. So it seems neither AccessDatabaseEngine nor AccessDatabaseEngine_圆4 works for me for either 32-bit office or 64-bit office.MS Office 2013 32-bit and 64-bit free download for windows pc. The "Openrowset" statement I tries was like: SELECT *įROM OPENROWSET('.12.0', Then I found "openrowset / opendatasource" statement, tried it on SQL Server, and got error msg: "The 32-bit OLE DB provider ".12.0" cannot be loaded in-process on a 64-bit SQL Server." The solutions I tried were the following:Ģ) instialled AccessDatabaseEngine_圆4 (checked registry key to make sure its registered) Ĥ) ran "openrowset / opendatasource" again but still got msg ".12.0" cannot be loaded in-process on a 64-bit SQL Server." Only now, I couldn't import excel (.xlsx) into SQL Server any longer, I guess because AccessDatabaseEngine was uninstalled ħ ) ran "openrowset / opendatasource" again, still got msg ".12.0" cannot be loaded in-process on a 64-bit SQL Server."ĩ) installed AccessDatabaseEngine, ran "openrowset / opendatasource" again, still got msg ".12.0" cannot be loaded in-process on a 64-bit SQL Server." The error msg is basically "Cannot initialized the data source object of OLE DB Provider 'SQLNCLI11' for linked server "Mycomputer".
And the import became successful.īut I'd like to make SQL Server to read local excel files dynamically without importing, so I decided to set up excel as server using "New Linked Server" function in SQL Server, but failed. When I had 32-bit office on my computer, and was using "import" function under "database" on SQL Server to import excel (.xlsx) data, SQL Server forced me to install AccessDatabaseEngine (the 32-bit). The question is: should I use AccessDatabaseEngine or AccessDatabaseEngine_圆4 in this case? And how?īackground - to make this question complicated:
My problems is: I installed "AccessDatabaseEngine_圆4.exe", but when executing "openrowset()", SQL Server gives me error msg "The 32-bit OLE DB provider ".12.0" cannot be loaded in-process on a 64-bit SQL Server." Please read the following so you'll know I did tons of research and trials. My goal is to let SQL Server read excel data, using "SELECT * FROM OPENROWSET()" statement. I am using MS office 2013 64-bit (after uninstalling 32-bit office 2013) on a 64-bit computer (with windows 10), and SQL Server 2014 Express connected through IP address.
0 kommentar(er)
