Forum Discussion
Can not able to import Excel File into SQL
Hi Team, I mostly working with Excel. Some of excel files having large amount of data (Eg. Around 8 lakh rows and 52 Columns) For getting some results, excel is hanging or taking more tim...
Try downloading and installing the Microsoft.ACE.OLEDB.12.0 Data Provider that is part of the Microsoft Access Database Engine.
Link:
https://www.microsoft.com/en-us/download/details.aspx?id=13255
The page here give more information about the process:
https://social.technet.microsoft.com/wiki/contents/articles/24236.importing-an-excel-spreadsheet-into-a-sql-server-database.aspx
Link:
https://www.microsoft.com/en-us/download/details.aspx?id=13255
The page here give more information about the process:
https://social.technet.microsoft.com/wiki/contents/articles/24236.importing-an-excel-spreadsheet-into-a-sql-server-database.aspx