8 hours 33 minutes
We're continuing being important. And in this lesson, we're going to talk about how to import from database.
Now, you have seen
that so far, we have been important important files from some formats. That is not
format for any kind of program. So takes a foul is standard text file for,
data in in plain text format, C S V standard data interchange formats. But if we click here from access and then we go to the documents, we click here and we're opening that. I mean, we are
getting the file directly from the database. So in success database
we want were asked, What are we going to report? Is it settings? Is it contacts or extended contacts? We just need the data, so only contact,
and again it's going to ask us work to put it. And how do you want to view this
data? So we do it just like table and in an existing worksheet and click. Okay. And we get the same thing like we got before just
open. A new file here. We have placed it in the work shed we wanted.
Now we're going to delete this because we're going to try something else. And we're going to get to this question
and basically excels ask you
that this is associated with the query that Rick use data from external source. This is happening when you're important data from a database.
they want to delete the query in addition to the range. And
in the 99% of the cases, usually just yes. And you do it. You have deleted the data. Now let's do the same thing.
But let's try to import
But is people table
and you get it automatically as people table. So, for example, we want Ah,
uh, sorry. Last name to be a row.
And we want to call him to be
And we want to calm to be
And we get this.
we have these phones or we can move these two rows,
and then we get
this kind of configuration so we can do a lot of things. Been important data from database. Of course, we need to know you're doing, eh? So, for example, we can We can put last name in filters
and then, uh,
you can, uh,
here on we consider just one person,
and we get these two
and so on and so on. So this is
very nice way to get data from database and analyze them at the same
And now we're going to delete them.
Now, we're not getting the query because we have opened. It does appear our table. So this is the way to import data from database. And let's just continue with the importing data
Just again. Just import data again from this
database just to have it for Evan Trail in future.
and it's here.
you have it
on now is do just import from text. So began we go to data received from text,
and we gets now the text file
with absolutely the same
ah, dessert that we did when we were opening. The only difference is we're now not going to be opening. We're going to be placing it in existence, worksheet
and, uh, finish.
And it's here.
it's important it
and it has done. It's slightly different because now these dates are
mike links, and some things have bean changed. But essentially, this is the same thing. And we have the same Arab. The
positioning of this This was intentional. Just to show you that when you're exporting to text files and important that again, some things can go wrong.
So this is the end of this Listen.
Data Analyst Excel
The Data Analyst Excel Test is a premium Cybrary assessment created by iMocha and intended ...
Monitor a Web App
In this IT Pro challenge, participants get hands-on experience activating server logging and using Application ...
Learn On Demand