Import data (.xls file) into SQL Server - I get this error

1.2k Views Asked by At

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)

2

There are 2 best solutions below

0
On

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

0
On

Few suggestions to avoid the installation of drivers. There are few options.

  1. 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.
  2. BCP IN the CSV file into the table.
bcp.exe {TableName} IN "{PathToCSVFile}" -c -T -t , -S {SQLServerName}