Connect SQL Server from Excel and retrieve data My SQL Blog: sqlwithmanoj.com/ #SQLwithManoj #SQLServer #MSExcel #ExcelSQL SQL blog: sqlwithmanoj.com/ LinkedIn: / manub22 Facebook: / sqlwithmanoj Telegram: t.me/sqlwithmanoj
Пікірлер: 67
@VANTYCSolutions3 жыл бұрын
Amazing video. I spent 1 hour trying to export from SSMS to excel with an annoying errors, but with this great tutorial finally my work is done Thank You.
@_-_-.-_-_2 жыл бұрын
I have been doing SQL for 25 years and decided to watch at random. I do this all day long. If I was not to know how to do this, this video is very good, both in the delivery of how and why. Also, the presenter spoke very clearly. Good job.
@WinserEspinal2 жыл бұрын
You just saved me hours of research, as a beginner, I thank you from the bottom of my heart.
@pandayprakash3 жыл бұрын
Ur tutorial give soo much guidance 👍
@ayushisahu99263 жыл бұрын
Thanks the vedio was so helpful
@mikegaa2 жыл бұрын
great tutorial. thanks
@CapsLock9594 жыл бұрын
You are a modern day hero, sir.
@smellypunks3 жыл бұрын
How do you refresh the data? Click refresh or can it be set with a timer e.g. 6am daily.
@wrathofindian61503 жыл бұрын
Excellent English, and great content helped a lot to build WMS
@عابثالأخير-ز9ي7 ай бұрын
Thank you! It was a great
@tauhidanwar35128 ай бұрын
Very nice and informative video. I am using office 365 and after connecting to sql server, i am not able to edit the query in connection properties. Please help
@rk_financial65922 жыл бұрын
Awesome...exactly what i was looking for!!
@stanknight91595 жыл бұрын
Fantastic Video! Thank you.
@GaganDeep-mj5hi9 ай бұрын
Awesome video
@funtime123452 жыл бұрын
That was great!!👍👍👌
@IbadassI4 жыл бұрын
Fantastic, exactly what I wanted!
@anthonyhernandez35464 жыл бұрын
This has so much value
@khdvid8013 жыл бұрын
Thank you.
@maynonarauz285 жыл бұрын
what if you change something on the excel file? would it change in the SQL table?
@MeyWorking4 жыл бұрын
thank you!! very useful!
@luirm69465 жыл бұрын
HI mate, quick question, how would I be able to update connection if I want connect to the same server but different SQL query and run it on the same excel sheet? Props to your video
@SQLwithManoj4 жыл бұрын
I think you will need to change the SQL Query everytime.
@akashkshirsagar31302 жыл бұрын
Hello sir ... its great learning as a beginner for me. when I am trying to connect multiple table at the same time, its not working. could u please help me for how to do it?
@rafaelagrava22396 жыл бұрын
is the data realtime? for example you add data in my sql server do you think it will update to in excel?
@ManojPandeyManub226 жыл бұрын
yes :)
@greengarden29945 жыл бұрын
Same question I had... should pin or highlight Rafael's comment. This video was very helpful, thanks Manoj!
@gabrielgomez23132 жыл бұрын
Pro!
@omoussalli6995 жыл бұрын
Thank you so much for this!
@tinachaulagai51775 жыл бұрын
You are the best.............
@hweegeem3 жыл бұрын
Hi, how if my data base is from an Excel file? It is .csv file, and the data is keeping on increasing as long as machine working. Do you have any ideas? Means my SQL need to auto update when there are a changes from excel file.
@nohemiwest-phelps5343 жыл бұрын
Great video. When I do this, it puts it into a table and I cant run my vlookups without changing the formatting and then the formatting is lost when the data is refreshed. My vlookups are done off loan numbers and that's the formatting that I have to adjust each time to remove the leading zeros. Any suggestions?
@SQLwithManoj3 жыл бұрын
Plz do not mix Excel-SQL-connection with vlookup... try to do vlookup in SQL itself and then pull data in XL.
@jacobsearl61922 жыл бұрын
create a macro that copies, pastes, and re formats the refreshed data.
@terasinfo77893 жыл бұрын
I have already thanked you
@silverfunnel68194 жыл бұрын
Liked! and subscribed! 4:27 But I could also delete columns in the Get and Transform Editor?
@chandraganji933 жыл бұрын
Great!
@JamsCademy5 жыл бұрын
Wonder full!
@msn4934 жыл бұрын
Hi Manoj ..the vdo is helpful but what i observed is when u r dealing with huge number of records ..the data in Excel and SQL do not match..over all row count is same in both but the data is mixed.. as in what i see in SQL first row ..i cant see the same in the first row of excel ? Why is that ..? Can u explain ..am i doing anything wrong? Pls help
@hdchiepduc3 жыл бұрын
a big help
@mohamedjiffry35984 жыл бұрын
Is there any risk on database if excel user connect to SQL DB? please advise.
@SQLwithManoj4 жыл бұрын
no, as you are using read-only connection from Excel to SQL Server.
@mohamedjiffry35984 жыл бұрын
Thank you
@santhosh8273 жыл бұрын
Kindly guide me on following query, when I delete 2 years data out of 5 years from a table using where clause it increased log data120 Gb, so how will remove it from log
@SQLwithManoj3 жыл бұрын
If its your DEV/Test database, try checking if the DB RecoveryModel is set to "Full", then set it to "Simple", and Shrink the log file. Or if its your PROD database, then try taking log backup and Shrink the log file.
@christianmax46593 жыл бұрын
really nice Video! does anyone know how I can change numbers in Excel and update it in SQL?
@andersonrodrigues6007 жыл бұрын
Good Job!
@mr.e2996 жыл бұрын
Great video but how to connect to a remote Server not on the same network?
@gautamranafounderofbexpert65395 жыл бұрын
Can you pls help me I am unable to connect Heidi SQL database . Thanks in advance
@ItsTarzan1004 жыл бұрын
Can you please suggest how to do this in Excel 2016 version, I was able to do it in previous version but some reason after excel is updated i am not able to connect.
@SQLwithManoj4 жыл бұрын
This demo is using Excel 2016 only
@ItsTarzan1004 жыл бұрын
@@SQLwithManoj sorry I mean office 365
@yogeshm59557 жыл бұрын
Thank you I am able to connect sql server. My sql database will be updating every ten minute. I want it should be updated every ten minutes and should save automatically in excell even when file is closed. Please help me.
@SQLwithManoj7 жыл бұрын
For this you need to use SSIS, that will run the query and redirect records in an excel file with dynamic file name.
@alltimez55235 жыл бұрын
Sir can you do it in reverse order Like when we change data in Excel it should update in sql server database
@sabkuchdhela1914 жыл бұрын
have the same doubt
@loomdoby4 жыл бұрын
subscribed
@sabkuchdhela1914 жыл бұрын
Wat to do for connection in MySQL with live excel updates.. if i update my excel, table gets updated in mysql
@SQLwithManoj4 жыл бұрын
no, updating Excel won;t update your table in database.
@shilpikhetan2743 жыл бұрын
Hey hi.. i also have this requirement. Would you successfull in achieving this ?
@sabkuchdhela1913 жыл бұрын
@@shilpikhetan274 there is a MySQL connector available in Excel..as plugin
@nyali22 жыл бұрын
This is from SQL to Excel, not Excel to SQL.. that is quite a difference