Go to Start Menu -> Microsoft SQL Server 2017( your SQL server version) -> SQL Server Import and Export Data (64-bit)> Open the application and try to import data using the “Excel 2016” option, it should work fine. you may need to install the 64 bit version of the Microsoft Access Database Engine 2016 Redistributable and try opening – the 64-bit “SQL Server Import and Export Data” directly. SSMS is a 32 bit client, if your Microsoft Excel is 64 bit. They need to be same, like 32 vs 32 or 64 vs 64 (System.Data)įirst thing first, install “Microsoft Access Database Engine 2016 Redistributable.”Īnd then also check the version of Excel and SSMS. The ‘.16.0’ provider is not registered on the local machine. A popular issue in importing the data which is in Microsoft Excel 2016 to MSSQL via SSMS (Management Studio).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |