excel import error to sql server To fix the issue of error during importation of excel file workbook to the database created in the sql management studio. Install the latest x86 and x64 vc redistributable. Then install the latest ole db sql.
link to the microsoft visual c++ redistributable
- install both x86 and x64 https://learn.microsoft.com/en-us/cpp/windows/latest-supported-vc-redist?view=msvc-170
link to Microsoft OLE DB Driver for SQL Server
- then install the ole db driver x64 https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver16