TITLE: SQL Server Import and Export Wizard
The operation could not be completed.ADDITIONAL INFORMATION:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)
Import data (.xls file) into SQL Server - I get this error
1.2k Views Asked by Ummehani Matkawala At
2
There are 2 best solutions below
0

Few suggestions to avoid the installation of drivers. There are few options.
- Save the excel file as CSV and then try to import it, using import export wizard. CSV is basically text file and you don't need specific drivers.
- BCP IN the CSV file into the table.
bcp.exe {TableName} IN "{PathToCSVFile}" -c -T -t , -S {SQLServerName}
A 64-bit version of the 'Microsoft Access Database Engine 2010 Redistributable' that will allow you to use the 'Microsoft.ACE.OLEDB.12.0' provider is available here:
http://www.microsoft.com/en-us/download/details.aspx?id=13255
If you use the download from the accepted answer, you will need to build for x86, as pointed out