Connect SQL Server from Excel and retrieve data

Connect SQL Server from Excel and retrieve data

#SQLwithManoj #SQLServer #MSExcel #ExcelSQL

[VANTYCSolutions]

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.

[_-_-.-_-_]

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.

[WinserEspinal]

You just saved me hours of research, as a beginner, I thank you from the bottom of my heart.

[smellypunks]

How do you refresh the data? Click refresh or can it be set with a timer e.g. 6am daily.

[wrathofindian]

Excellent English, and great content helped a lot to build WMS

[rk_financial]

Awesome...exactly what i was looking for!!

[maynonarauz]

what if you change something on the excel file? would it change in the SQL table?

[tauhidanwar]

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

[silverfunnel]

Liked! and subscribed! 4:27 But I could also delete columns in the Get and Transform Editor?

[luirm]

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

[rafaelagrava]

is the data realtime? for example you add data in my sql server do you think it will update to in excel?

[akashkshirsagar]

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?

[msn]

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

[nohemiwest-phelps]

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?

[hweegeem]

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.

[mr.e]

Great video but how to connect to a remote Server not on the same network?

[nyali]

This is from SQL to Excel, not Excel to SQL.. that is quite a difference

[christianmax]

really nice Video! does anyone know how I can change numbers in Excel and update it in SQL?

[gautamranafounderofbexpert]

Can you pls help me I am unable to connect Heidi SQL database . Thanks in advance