Forum Discussion

Copper Contributor

Nov 05, 2023

How to import data in SQL server from excel

Hello Experts I am trying to import data from Excel to SQL server table using OPENROWSET and it gives me below error. Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine” I...

olafhelper

Bronze Contributor

Nov 06, 2023

Santosh20

My Excel file is placed on Azure storage account

ACE data provider don't support Azure storages.

Santosh20

Copper Contributor

Nov 06, 2023

Thanks olafhelper,
So could you please suggest me a workaround?
How I can read data from Excel using OPENROWSET in SQL MI ?