Use Excel to Connect to SQL Server Data

Connect directly to SQL Server data from within Excel. Also learn how to add and modify SQL statements from within Excel and pass them to SQL Server for data retrieval. If you need to quickly refresh data from SQL Server without hassle, then you need to watch this video!!

★☆★ Join this channel to get access to perks: ★☆★

★☆★ FOLLOW ME BELOW: ★☆★

☕☕ If my channel has helped you, consider buying me a coffee! Thanks & Cheers! ☕☕

★☆★ Support this Channel: ★☆★

#Excel #SQLServer #analytics #data #dataanalyst #education #onlinelearning

[eborne]

I'm totally new to SQL and usually dive into the deep end of things. Had to do some homework before understanding what you were doing but once I did that, you came thru clear as a bell. Thanks!

[ferdousrahman]

Hey! Just wanted to say a quick thank you for the Excel to SQL Server tutorial on YouTube. It's been a game-changer for my office reports, making everything faster and stress-free. Your help is much appreciated!

Cheers,

[souravroy]

Thanks sir. After a long search I found this video. I was looking for how to edit SQL query in OLEDB Query and this video exactly shows how to do that.

Thanks again 😊

[rijzdlk]

great video just what I was looking for.
Thanks

[jackiehay]

Great video and I am now a subscriber. Your instructions are concise and easy to follow.

[FraIvan]

First time on your channel! Great work Anthony!

[snapperhead]

Very nice, exactly what I was looking for; thank you very much!

[joerevanth]

super helpful and hassle free explanation.

[ZeuSonRed]

Good job dude, unexpected perfect. Do some more, bless

[kichooze]

What to do if I want to display the server name (data source) in a cell . When we have multiple boxes would like to display the source in the sheet itself.

[kavasr]

Hi, thanks for the explanation! It was driving me crazy that I could not edit my query. I assume this is some Office 365 "feature" because I used to edit it in the properties using Excel 2016.

[El_prof]

great videos !!!!
Simple and Nice man !! tnx

[christianschroeder]

Hi dude I was wondering if you can answer me the following question. I am working on a project with a large scale data set in excel as the central point. This data set will be updated on share point by multiple users i.e. completion dates of the work and what not. This data set is stored on sharepoint and multiple different stakeholders require a cut off version of the master data set just with the relevant information. what I have done is to create a new SS to let's say Antony as an example and cut down the data based on his needs via power query to meet his needs. I have deployed a direct URL connection for Anthony to to the Master file in Share point and did a setup of a data refresh every 1 min of the source data for Anthony. However, even that the solution works, the new entries for Anthony's customized report out of the master data set take a hell of a lot time and refreshes until I can see the updated data in excel . In other words if I change something on the master file, refresh the query for Anthony, the changed data needs minutes to reflect that change. Is there a way to optimize power query in excel to reflect that change of data in real time ? The problem is that I have to create multiple customized data sets which are pointing back to the master file plus I have multiple data sets of third parties which feeding back into the master file, meaning once those get into my master file the sub sets of data created for certain stakeholders need to refresh. Does this makes sense bro ?

[mirmir]

How do I create macro button to update the dates to fetch data from the same query

[tph]

Very simple and straightforward explanation, thank you! I have a problem that is maybe similar to this - do you know if there's a way to pull in data from a source published in Tableau Server directly to Excel/Access (or even Python)? Where I work, we don't have access to the original database tables, but we can connect to the published Tableau server data sources. I was wondering if there was a way to eliminate the "middle" steps (data source > creating a workbook in Tableau > building the view/filters > exporting to Excel/Access db). Sorry if this question is more appropriate for another video. Thanks again!

[MethodOverRide]

I'm doing this for some ad hoc reports but I find that the refresh is sometimes slow when importing about 10 or 15 sheets of data that have 1k to 15k of rows per sheet. However if I don't use Power Query and connect Excel directly to my SQL views it refreshs much faster. But the trade off is the setup of each sheet to each view and often times a re-setup if there are substantial updates to the view.

I like the flexibility of Power Query, but I'm not sure why it takes so long to refresh the data. I'm wondering now if VBA using an ole db connection to the database with SQL queries to pull the data is the way to go.

[sqlservertutorialinminute]

Hi, can we change authentucation to SQL authentucation? Thanks

[jeiohmn]

Hi Anthony, this is great. However, one issue I'm having is that the next time I open the workbook the data connection and associated quesry aren't being saved. I get an error saying the query was not found. How do I resolve this issue?

[rajasgodbole]

Is there a way for the SQL query to pick up parameter from Excel cells? Lets say there are dates in A1 and A2 cell. And I want the query to pick up these Dates for Where condition in SQL and query database.

[danilotavares]

Is it possible to dinamically change the SQL statement based on specific cells values? For example, you could create a cell to specify how many top registers you want to get.