How to import data from excel to SQL server || Import excel data to SQL || Ms SQL

preview_player
Показать описание
Want to know how to import excel sheets data to SQL server tables ? then please do watch this video

In this video I have disucssed about importing data from Ms Excel to SQL Server and common errors and its troubleshooting.

::Click on below lin to download Microsoft Access Database Engine 2016 Redistributable::

::Start the SQL Server Import and Export Wizard in 4 ways. Click on below link to know more::
Рекомендации по теме
Комментарии
Автор

Thank you Sir for this great video especially after two days trying to solve this common errors. GBU.

hendrag
Автор

I want to hug you buddy!
Saved my life
Thankyou thankyou 🙂🥺

rajeshkumark
Автор

Ur sql server explanations & demos are very good BK. Thanks a lot..

Pls include upgradation, patching & performance tuning as well..

Coming to the performance tuning:
1. Locking, Blocking & Deadlocks
2. Isolation levels & Concurrency issues
3. Query tuning & Optimization
4. Creating Indexes & solving Fragmentation issues

ashketchum
Автор

Getting error as Microsoft.ACE.OLEDB.12.0 provider not regisyered onnthe local machine. While selecting the excel path. Not sure whats wrong.

madhureddy
Автор

Sir, i will get this error excel 2007-2010 verson. So what can I do?

Jami_Sarat_Kumar
Автор

What about updating the recording from excel file to sql server

nikhilvairat
Автор

Sir please provide video on locks, deadlock and indexes.

santoshsistu
Автор

That's fine but how make primary key.. After importing from Excel to sql

anilredddykanthala
Автор

what to do if I don't have Ms-excel not installed on my laptop ??

akm
Автор

Import excel to MS SQL with query without using task

parajf