5.1 Importing From Spreadsheet Files Part 2

Video Activity
Join over 3 million cybersecurity professionals advancing their career
Sign up with
Required fields are marked with an *
or

Already have an account? Sign In »

Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9
Video Transcription
00:02
Okay, so let's continue opening files by opening,
00:07
um,
00:11
text file.
00:12
So this is going to be the same file,
00:16
but it was saved as a text file,
00:20
and I have used tabs
00:22
as a D limiter.
00:24
So it's slightly different because, you see, the encoding is windows and see, I'm still going to select it. Toby delimited file. It has Heather, so it's pretty much the same.
00:38
Now it's Tab,
00:40
and we're not going to do this. And we're going to continue
00:45
and
00:47
pretty much the same thing and we get
00:50
almost identical thing. The reason is because I have used my old Excel file Excel s and saved it into different
01:00
types.
01:03
So, um,
01:07
what you get here, you see, is that because it was tapped, the limited and it had a lot of space is in here.
01:15
It
01:17
it didn't put these three cells in their proper place
01:23
because they
01:25
should be
01:26
here
01:30
because this is the sum of total mileage, total private mileage and purchase about petrol purchase. So this is
01:38
this is how it should be. So when you're doing with CS freeze, you get pretty much exact file like it should have been
01:46
when you're working with text files. It can be tricky sometimes.
01:52
Um,
01:53
so it needs additional work. And this is just for you to see the difference
02:00
between those two.
02:02
So let's continue with importing Azari opening, and we're now going toe open.
02:10
Ah, database file.
02:14
So, uh,
02:17
have
02:19
documents, one data base file.
02:23
And it's sorry it's this one
02:30
and
02:35
off course. It will sometimes give you something like this
02:39
and what I want. I want contacts from this. So this is some
02:45
invented contacts file.
02:49
And I wanted, like, table people date that people table report, people chart
02:55
on Lee just to create the connection
02:58
or
03:00
toe cope. It just in s o. I wanted, like, table in existing worksheet,
03:06
and I said, Okay.
03:08
And I get this.
03:09
So this is
03:12
standard excess.
03:15
Ah, template for, uh,
03:20
contacts list. And I have just entered some of three lines just for you to see, so I haven't filled everything. So, for example, here I don't have
03:31
ah,
03:32
business phone.
03:34
I don't have home phone. A total effects number. Nobody's using them anymore, so I didn't feel them addresses, not their cities, not their state province postal codes, country that page category is personal. So this is how it
03:52
looks when you open database file. Now, what is important for you to understand is that we haven't
03:59
opened the database file. We have just opened the data from database file and important into Excel.
04:06
So first of all, Excel cannot open access database, but it can access
04:14
this database and extract data from it. And this is what it has done.
04:18
So you have seen now how we open
04:24
and how Ah! Text file, excel, file and comma, separated file, text, file and database file. So this tree,
04:38
now the next step would be
04:41
to, uh
04:45
see what is the difference
04:47
between opening and importing before we go to importing.
04:51
So opening Powell's files makes a whole new world book or
04:58
puts it in a in a data sheet.
05:01
Uh, it is done through open dialogue,
05:04
while important data from files allows you to place them wherever you want in the worksheet.
05:12
And the importing data is then using data tab and two groups get external data and get interest form groups.
05:24
And we're going to talk about that in the next lesson.
Up Next