This provides a walk around to resolve issues in SQL Server while importing data from Excel.
The problem statement is as follows : The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data)
Steps to do :
1. Open the original Excel file.
2. Save it as Microsoft Excel 97-2003 Worksheet (.xls)
3. Repeat importing it into SQL Server.
Xem thêm bài viết khác: https://12m-15m.org/category/cong-nghe