Importing Excel file data to MS SQL Database using SSMS can come with some challenges.
When your data is over 65k records, you wouldn’t be able to use the 97-2003 version as you will lose data.
Most of the time, the SSMS and MS SQL Server are running on 32 Bit and you will need to install a missing component Microsoft Access Database Engine 2016 Redistributable.
You are to download the 32Bit version even though you run a 64Bit Machine.
You are likely to have challenges installing the 32Bit as seen in the video, but using the cmd
1. Cd to the directory where you downloaded the setup
2. Type the name of the setup file including the extension .exe
3. type "/quiet" to bypass the error and get the 32Bit version installed.
Link to the Access Database Engine Setup : www.microsoft.com/en-us/downl...
Useful resources
Kaggle Data: www.kaggle.com/arashnic/imbal...
Setup SQL Server on your PC and Install Adventureworks Database: • Practical SQL Beginner...
Understanding Adventureworks Database: • Understanding Adventur...
#sql #database #ssms
Негізгі бет Ойын-сауық How to Fix SQL Database ODBC Driver Error
Пікірлер: 343