Datasheet

El Import Text Wizard
Vy'hat delimiter separates your fields? Select the appropriate delimiter ard see hco.....iyour text
is affected in the
Choose the delimiter that separates your fields:
Tab
41 I
Adlanced... I
Semicolon
Cancel
Comrna
C Space
r Other:
< Back
Next > Finish
INA
5 2001 .;
5 1500 27 . 54 3.35:3 1.429 2.762 1.366
5 2001
=4
5 1600 2.5 . E; 6 2.29 1
. 09.5
1 . 423
1 . 3F;
S 2001
:".1
5 1700 25.76 2.222 1.094 .94
1.244
5
? 001 95 1;E; 00 2 4
. 41 2 . 1:37 .921
. 294
1.04
5 2001 ; 5 1900 2:3 . 0 S 2.165 .634
. 044
.47
c", ?cum
=.1 5 21-11-11-1
21.6
2.179 .4
ii
. 4E;
I First Row Contains Field Names Text Qualifier: 1-;..rionei:-
45
Manual
Data Processing in MS Access and Final Storage into the NBD
The Report output files are comma-separated and thus fall into the category ‘delimited’. This has been done on
purpose since importing this format into MS Access has proved to be straight forward and flawless. Continue with
step 9.
Step D9: Select ‘Delimited” and click ‘Next’. The screen illustrated below appears; it shows how the imported text
will be divided into various columns according to the applied delimiter.
Step D10: Select ‘comma’ and click ‘Next’.
The subsequent window (shown below) is used to define the output location for the imported data. In this particular
case, the new information is to be imported into an existing pre-defined auxiliary table Meteo_Hourly.