Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

Video Transcription

00:00
okay,
00:01
We're continuing being important. And in this lesson, we're going to talk about how to import from database.
00:07
Now, you have seen
00:09
that so far, we have been important important files from some formats. That is not
00:15
standard
00:18
format for any kind of program. So takes a foul is standard text file for,
00:26
um
00:27
ah,
00:29
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
00:46
getting the file directly from the database. So in success database
00:52
and no,
00:55
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,
01:07
and again it's going to ask us work to put it. And how do you want to view this
01:15
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
01:26
it was
01:27
open. A new file here. We have placed it in the work shed we wanted.
01:33
Now we're going to delete this because we're going to try something else. And we're going to get to this question
01:41
and basically excels ask you
01:44
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.
01:55
So
01:56
ah,
01:57
they want to delete the query in addition to the range. And
02:01
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.
02:12
But let's try to import
02:15
from access,
02:20
just contacts.
02:23
But is people table
02:27
and you get it automatically as people table. So, for example, we want Ah,
02:34
uh, sorry. Last name to be a row.
02:38
And we want to call him to be
02:40
business phone.
02:44
And we want to calm to be
02:49
mobile phone.
02:53
And we get this.
02:59
So
03:00
we have these phones or we can move these two rows,
03:07
and then we get
03:12
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
03:25
and then, uh,
03:28
you can, uh,
03:30
here on we consider just one person,
03:34
and we get these two
03:38
and so on and so on. So this is
03:40
very nice way to get data from database and analyze them at the same
03:46
time.
03:49
And now we're going to delete them.
03:52
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
04:04
from text.
04:06
Just again. Just import data again from this
04:12
database just to have it for Evan Trail in future.
04:16
So contacts,
04:18
they bow
04:21
and it's here.
04:23
So
04:24
you have it
04:25
like this
04:27
on now is do just import from text. So began we go to data received from text,
04:33
and we gets now the text file
04:38
with absolutely the same
04:40
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
04:51
and, uh, finish.
04:57
And it's here.
04:59
So
05:00
it's important it
05:02
and it has done. It's slightly different because now these dates are
05:09
mike links, and some things have bean changed. But essentially, this is the same thing. And we have the same Arab. The
05:19
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.
05:30
So this is the end of this Listen.

Up Next

Intermediate Excel

Being an intermediate level user of Excel can help save a user hours of work time and take full advantage of the Excel application. Taking an intermediate Excel training will help students advance their skills and pass an intermediate Excel exam.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor