Download Ace Oledb 12.0

* Apply the SQL Server configuration settings to allow ad-hoc distributed queries

* Use the Microsoft.Ace.OLEDB.12.0 drivers for xls and xlsx files

* Install the Microsoft Access Database Engine 2010 Redistributable (64 bit version), this requires there to be no 32 bit version of Office on the computer

* Use sp_MSset_oledb_prop to set AllowInProcess = 1 (without this option, OPENROWSET sometimes causes the SQL Server Service to stop running)

* Add the -g256 or -g512 startup parameter to the SQL Server Service (this gives more memory for the ACE drivers)

Download Ace Oledb 12.0

Download Zip

Try to reduce the table to 1field . Then load the table. If no error,add 1 field, load table of 2 fields. If no error add other field until you get an error. Then you will focus on which field make the error. I think some field make the oledb error. Delete the field or do something else to make it correct.

We have first installed July PowerBI x64 version on 8 systems and got an error "microsoft.powerbi.oledb is not registered" on all of them. We reinstalled to the latest version last week and same thing is happening. The systems are running Win10 with MS Office (32-bit) also installed.

You can view and change the properties of the OLEDB provider. Only the masteruser can perform this task. All linked servers for Oracle that are created on the DBinstance use the same properties of that OLEDB provider. Call thesp_MSset_oledb_prop stored procedure to change the properties of theOLEDB provider.

caa09b180b