Saturday, 10 July 2021

Import Excel into SQL Server


Currently a Covid Lockdown in Sydney and so I'm bored. Therefore, I decided I'd share some knowledge from all the years of ETL work I've done. 

In this video I show a simple way to get around an annoying "Microsoftism" when doing what should be a straightforward import of data from Microsoft Excel in SQL Server. 

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)

If you've ever tried using the SQL Server Import and Export Wizard, and received that error, you'll know how frustrating it is ... 

Here's the solution: