MS SQL Server - Management Studio - Import excel sheets as tables into database

[@mark9549]

Thank you is the least little word to express my gratitude.

[@Sagar8ars]

Your the man bro... This is how ppl should show in simple and understanding way....

[@trendsandmore911]

Just what I was looking for! No BS, straight to the point

[@forimax9642]

bhaskar bhai 10 video k bad aapki video kaam aai thanks man loved it thanks

[@HamsterWorld007]

Never ever seen such a good explanation

[@waverider80]

Didn't work for me. After changing the Excel version to 2016, I received an error: "The operation could not be completed: The Microsoft.ACE.OLEDB.16.0 provider is not registered on the local machine. (System Data). Still a good video... I voted thumbs up.

[@kristian326]

I have the same problem. I've tried installing the provider but it still without working.

[@vladimircapka1519]

If you have this problem, open excel sheet and save it as 97 year type. then import that old excel as 97 and it works :) have a nice day

[@swapnilgaikwad9771]

@@vladimircapka1519 : but it will not import all records then?

[@patricius1509]

try excel 13, i have same problem, but i go next after default option after click "browse"

[@paragdasgupta4981]

@@vladimircapka1519 thanks bruh. Btw, r you Czech?

[@Hustling_Learning]

Great Video, thanks man..., one error comes there for 32 bit and 64 bit version for that we have to run sql server import and export wizard seperately, rest this is the best video regarding import in sql...

[@jitinroy2246]

thanks

[@everythingdigitalwithjoseph]

This is perfectly done. I'm following you asap

[@galaxy_george]

Quick, clear and to the point! Thank you a bunch !

[@aakashshanavas8437]

Thank you. That was so helpful.

[@satyenkasturi]

Thanks... helped me exactly what I was looking for.

[@rdp9875]

you save my time on sql work

[@aripurnomo9568]

how to import from excel automatically to the database, for example excel is stored in a folder then automatically saved in the database

[@suresh2137]

Thanks man, 2 suggestions please add audio also and video is 480p due to which it's not visible

[@BhaskarReddyPulsani]

the video is full hd. change the setting on youtube to hd for clarity

[@voornaamachternaam9218]

Quick fix... Just the way I like it. Thank you.

[@alexsandrogarciacruz3700]

Y si quieres poner un ID auto incrementable a esa base de datos se podría??

[@chrismccafferty83]

If i make a change to the excel file will this reflect in the SSMS table?

[@richasalan4870]

Thankyou sir, it is very helpful video

[@parameshpenikelapati3217]

thank you sharing valuable information

[@jaimec4572]

I have a situation when I try to import to sql server Microsoft ace 16 doesn't register but I installed what I can do with this situation

[@odayaguzman2156]

Thank you, your video helped a lot!

[@netishmb761]

Sql server native client is been not showing for me during export can anyone help me regarding this 😢

[@schmugo9605]

When i try to execute, it says the execution is error. so that when i go back, the table still there but the data didnt get inputed

[@tahirarehman6]

Thank you so much- It worked for me, you are a great help

[@mediatasolutions5916]

Very excellent, thank you. Totally don't get all the dislikes.

[@bhaveshrawat1364]

Thanks this helped a lot!

[@likeinmotion3644]

how to import excel file with more than 255 columns in a sheet

[@azhari7968]

can someone help me please? when I click Edit Mapping... 2:23 the sql server import and export data closes itself

[@ayushisahu9926]

Thanks the vedio was so helpful but facing few error

[@obivolgaz1661]

Hi brother, meku postgresql windows machine lo telusaa.

[@dinahany233]

SIR AM HAVING THIS ERROR AFTER INSTALLING THE Microsoft Access Database Engine 2016 Redistributable.. HOW TO FIX IT PLZ The operation could not be completed. ------------------------------ ADDITIONAL INFORMATION: The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)

[@asadazer1838]

Thank you very much! :)

[@surajsatav5512]

I need to load the data from excel to a table in SQL Server 2008 and automate the updates.ie., If there is a new record or an update to the existing record in the source excel it should automatically update the SQL Server Table. Could you please help me out??

[@BhaskarReddyPulsani]

There seems to be some options for that. Did u try linked server imports in sql server. Or doing some macros programming. Or creating some routine using c#

[@someonehadtosayit5030]

Thank you very much kind Sir!!

[@yukizhang924]

I think it is super useful at least for me. Thanks!

[@mansijswarnkar2183]

TITLE: SQL Server Import and Export Wizard ------------------------------ The operation could not be completed. ------------------------------ ADDITIONAL INFORMATION: The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) ------------------------------ BUTTONS: OK ------------------------------

[@alternativeenergyresearch4857]

How to import xlsm macro sheet into database so that every one minute data is stored in database

[@thezentleman9730]

Native client 11.0 is missing

[@8686rohit]

Thanks a lot for this video

[@anandpandey9997]

Really Nice and Helpful......…. Thanks a lot... :)

[@thebhaskarjoshi]

Showing error - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data) What's the solution?

[@PoojaPooja-yi2qb]

@Bhaskar Joshi. Did u get the solution?

[@thebhaskarjoshi]

@@PoojaPooja-yi2qb No

[@nidhipatel5916]

very very useful for me.Excellent.

[@talhach167]

there were multiple sheets in excel file. How to load all sheets?

[@sky_trotterb]

Great

[@pramishprakash]

Perfect

[@mansijswarnkar2183]

showing OLE DB error

[@rajusheker]

very useful thank you

[@Felipe.Silva.Varela]

Thanks!!!

[@slmn9676]

superb

[@monalimasa1522]

Thanks

[@rajugoud1563]

Excel 2016 is not working in sql

[@raisazesira5483]

Helped alot 🖤

[@4ayniy_paket]

thanks, dude :)

[@subbareddy4966]

thank you for the information

[@md.ejazulhassan7933]

What i give in server name?

[@anurajnambiar6180]

Thank You!

[@rajashekhar.jeshollu278]

Thank you

[@tahirarehman6]

Great stuff

[@ankhbaatar7234]

thank you so much!!!

[@toledo980]

THANK YOU MY MAN

[@monicanavarro4997]

is it just me or does this video look blurry?

[@BhaskarReddyPulsani]

View it on 1080 resolution monitor. The is full HD

[@hlalefikgasago8856]

Thank you man

[@Catzzye]

2:58 ...?

[@shrutidhariya8996]

Helpful!!

[@omarsebakhi]

Very Big Like!

[@MKleinn]

tks my man!

[@Jmtreciever2]

Error

[@pew4410]

TITLE: SQL Server Import and Export Wizard ------------------------------ The operation could not be completed. ------------------------------ ADDITIONAL INFORMATION: The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) ------------------------------ BUTTONS: OK ------------------------------

[@BhaskarReddyPulsani]

Already received similar error. May be u can try this kzbin.info/www/bejne/ap2zdKJof6t9n9U

[@simomncube9177]

Thank you!