Forum Discussion
Santosh20
Nov 05, 2023Copper Contributor
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
Nov 06, 2023Brass Contributor
Hi,
would you try to import the excel into SQL server using SQL server Import And Export Data Console Window.
would you try to import the excel into SQL server using SQL server Import And Export Data Console Window.