I welcome back to Module six Sequel in applications We are moving into lesson to excel on. This is sub Listen to point to what we're going to do in this lesson as actually prep our Excel for getting data from the my simple database and to prep it, we're actually going to need to install an O. D. B C driver.
Now an O. D. B C driver is a special type of driver that allows Windows to connect two different types of database. So naturally we need the my sequel O D B C drivers and ah, typically, the different
types of databases have different O. D B C drivers
that you will need to install.
So I'm at the my sequel download session for the oh DBC driver and A the U R l for this download will be in the material for this lesson as well. So look for there if you need help finding it with that said, I'm gonna go ahead and start the download.
Go ahead on and download the top one.
Actually, I think I'm gonna get the 64 bit.
No, thanks. Just start my download
and it didn't take too long at all.
Go ahead and open the file that I just downloaded.
You want to say Okay,
Next I accept the license agreement
and I'm going to go with the typical set up type
and click through the admin prompts with a yes
finish. We need to go into our oh DBC driver settings.
So if we open up the Windows 10 search problem prompt and just search for oh DBC
and sold the 64 bit version Something go there,
I'm going. Thio, go ahead and put it under the user D S n If you wanted to share it across users, you would of course, want to use the system d s in. But I'm just gonna use the user. One
Let's choose the my sequel. Oh, DBC ansi driver.
It's like to finish,
and here we type in our connection criteria.
So we're gonna type in what we've been using
Actually, we need to put this here.
I'll just say this is the local. My sequel
on type in your user name and password.
Oh, I forgot a period
Okay, I was typing it in the wrong password. I have a ton of passwords. So occasionally I do that. So test
next thing successful,
we just connect to the axiomatic A database. Yes, we can. So we'll go ahead and select the axiomatic in database it. Okay,
And I'm gonna hit. Okay,
And I'm gonna go ahead and close. Ex, actually, let's go in and check to see if it sees that connection
from other sources on ABC
on the local. My sequel. That's the one I just made.
And the next lesson we're gonna go ahead and connect to our my single database and connect to the schematic a database to be specific. We're gonna graft the results of that same query with that we used in the power bi I module. And we're gonna look at how to refresh that data as well from Excel, which is very useful
for a lot of business users. Because in my experience, I've found that a lot of business users really love excel,
and a lot of them are excited if you get them a data connection to excel that they can refresh their Selves while in excel. Anyways, that completes this lesson. And I hope to see you in the next. Thank you