How to import data in SQL server from excel

Question

Hello ExpertsI 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”&nbsp;I'm using above provider in my code, can someone also correct me if I am using correct provider or I need to use different to read data from Excel?My Excel file is placed on Azure storage account and I am using UNC path to read data in SQL script&nbsp;Thanks&nbsp;

arshad440 · Answer

Hi,would you try to import the excel into SQL server using SQL server Import And Export Data Console Window.

olafhelper · Answer

Santosh20&nbsp;My Excel file is placed on Azure storage account&nbsp;ACE data provider don't support Azure storages.

santosh20 · Answer

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

matt_griffiths · Answer

Have a look at this Q&amp;A https://learn.microsoft.com/en-us/answers/questions/1319599/how-to-fix-the-microsoft-ace-oledb-12-0-provider-i

arshad440 · Answer

could you provide the script you used.

Forum Discussion

How to import data in SQL server from excel

Resources