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!

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

great video just what I was looking for.

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.

First time on your channel! Great work Anthony!

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

So glad I found your channel!

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

THANK YOU!!!!

super helpful and hassle free explanation.

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

great videos !!!!

tks bro

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.

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!

Hi, can we change authentucation to SQL authentucation? Thanks

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.

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.

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 ?

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?