I was recently using SSIS (SQL Server Integration Services) in SQL Server 2012 to attempt to import an Excel spreadsheet into a SQL Server database table, when I encountered the following error message:
After doing a bit of further research, I discovered an article which pointed to this download:
So after installing the Microsoft Access Database Engine 2010 Redistributable (I installed the 32-bit version), I was able to successfully import my Excel spreadsheet using SSIS!!
No comments:
Post a Comment