Unknown's avatar

Import from Excel to SQL Server 2012 – The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine

I hit this one trying to load Excel data into a table on my development server. Most recommend the “Microsoft Access Database Engine 2010 Redistributable” which didn’t work for me.
This one did: “2007 Office System Driver: Data Connectivity Components

as per: “ConnectionStrings.Com