Ziil
Reputation: 351
import from excel to sql server: The 'Microsoft.ACE.OLEDB.12.0' provider error
I want to import data from excel to sql server, but I got error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
op: windows 10 64 bit excel: 32 bit
There is no problem with older excel format xls, problem occurs with xlsx format. Is there any esay way to fix this?
Upvotes: 3
Views: 12670
Answers (1)
Charles Okwuagwu
Reputation: 10866
install the following file from microsoft to fix this issue
https://www.microsoft.com/en-us/download/details.aspx?id=13255
Upvotes: 4
Related Questions
- "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" Error in importing process of xlsx to a sql server
- Import from excel error Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine
- SQL Server and Microsoft.ACE.OLEDB.12.0
- Error when importing Excel in SSIS
- Excel into SQL Server with Microsoft.ACE.OLEDB.12.0
- Import Excel Sheet into SQL Server Getting Error "The OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server “(null)”"
- "Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" while importing data from Excel sheet to SQL Server using C#
- Error message when importing data from excel to SQL Server
- Import data from Excel into SQL Server
- Importing data from Excel to SQL Server database using Microsoft.ACE.OLEDB.12.0