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...

Arshad440

Brass Contributor

Nov 07, 2023

could you provide the script you used.

Santosh20

Copper Contributor

Nov 09, 2023

I am using
Select * from oenrowset( provider name and path of Excel file)