Use Excel To Connect To An Azure SQL Database

Creating and using SQL Server in Azure is more common than ever - but how do access these databases with Excel? In this video, I'll show you how!

Did I mention Something unique in the Video?
In this section, I try to put any citations, references, and links that might be useful to the subject of the video.

Join me on my podcast where I share ideas on how we can take a science-based approach to learning. On the podcast, I share ideas, book reviews, best practices, and more about learning.

Links I like to share:
Skillshare: I have courses on Skillshare and am adding more
A free course I created on Excel - I'm planning to create some more courses - let me know what you think. It's a work in progress.

My Favourite Gear
Here is my Amazon Store - I try to keep it updated 😁
Canada
US Store

Social Links

About…me.
Hello there - I'm glad you've taken the time to look at my videos and this description box!
My name is Frank and I've been teaching post-graduate programs in technical subjects for almost 25 years. My Master's Degree is in Learning and Technology (from Royal Roads University in Victoria, BC - where they filmed the X-Men movies!).

I'm a Microsoft Certified Trainer (since 1998), a Cisco Certified Academy Instructor (since 1999), and have a lot of different technical certifications (I even had my own consultancy and was a member of the Apple Consultants Network for a few years. I like technology a lot.

I've been fascinated with learning and how to improve learning for years. Especially how to leverage technology for learning. From productivity Applications like Teams, OneNote, Excel, and the entire Microsoft Office suite to tools such as Mindmapping, Metaverse, VR, AR, and more - I like to see how we can use tools to leverage our ability to teach and learn.

Learning and Technology YouTube is about helping students and teachers improve their learning by leveraging technology tools. Whether remote teaching, distance learning, hybrid teaching, or completely in the classroom - we can use technology to enhance our skills. This channel is dedicated to developing teaching and personal productivity when it comes to learning and technology. Thank you for watching!

Note: some of the links to other sites may be affiliate links that I get a referral fee for.

#Azure #Excel #Data

[wasay]

In 365 Desktop version, Azure only has Datalake storage and Data Explorer options. No Azure SQL Server. At least not on mine.

[jaytv]

what if you are bringing in more data than excel can handle? Is there a way of live connecting to azure data?

[Duvancillo]

i got an error, it says that the database isnt accesible and it doesnt allow remote conections, and in the configuration of the azure sql server i cant find an option to activate it

[denzoli]

Does it work the other way around? If I modify something in Excel, does it save it into the Azure SQL table? I would need the sulution to this...

[MandM]

Does excel has to be opened so that the connection will be updated every 60 minutes? Minute 3:20

[dellmo]

Hi Frank, great video, thanks! Within the Get Data menu I don't see all the Azure menu items that you show, only the bottom 2. Any ideas? I was able to use a more generic connection but I'm hoping to use an AD username and password which is not available from the generic connection. You mention using AD, is that available through the connection you used?

[connelchen]

I think in case you are using office 365 - the full connection menu options do not exist.