Page 56 - Database-En-V3

Import EXTERNAL DATA

It is the process of copying data from another source to the database, such as a new data
table in ACCESS:

The data is entered as a new table into the database.
• If the data is currently stored in another program, such as Excel, you

can copy and paste it into a table in Access. In general, this is the best
method especially if the data is already divided into columns, such as
in an Excel worksheet. If the data is in a word processing program, it
is best to separate columns of data using tabs or transform the data
before it is copied to a table in the word processing program. If the
data needs to be edited or processed (for example, dividing full names
into first and last names), it is best to do so before copying the data,
especially if you are not familiar with Access.

• When you paste data into a blank table, the data type of each field in
Access is set according to the type of data in which it is found. For
example, if a pasted field contains only date values, the Date/Time
data type is applied to that field in Access. If the pasted field contains
only the words Yes or No, the Yes/No data type is applied to the field
in Access.

• Fields in Access are named based on what is found in the first row of
pasted data. If the type of the first row of pasted data is the same as
the type of subsequent rows, it will be treated in Access as part of the
data and the fields will be assigned common names (such as F1, F2,
and so on). If the first row of pasted data is not the same as the
following rows, it is treated in Access as containing field names.
Accordingly, the fields in Access are named and the first row is not
included in the data.

49 Training unit in the field of technological information - at the Supreme Council of Universities © Intellectual property rights 2024