Datasheet

41
Manual
Data Processing in MS Access and Final Storage into the NBD
the actions for importing ASCII text file “metdayXX.txt” into MS Access are equivalent to those for “methrXX.txt” and
“metrnXX.txt”, only table and file names differ. The same applies for running the various queries and adding the fully
processed data to the NBD.
It is because of this fact, and the wish to avoid redundancy, that this manual presents the detailed user instructions
for only one member of each data type. The instructions for the remaining members are analog.
Last but not least, if the user decides to suitably rename the output ASCII text files – as described in chapter 5 then
the original names of all the respective ASCII output text files given in table 4 above will be different; in this case,
each file name will have a three-letter prefix and underscore added to indicate the station name. To illustrate this by
using the same examples as in chapter 5, the name of the file “metday31.txt” would change into “KAD_metday31.
txt” and so on.
6.3 Importing Output ASCII Text Files Generated by Report into MS Access
This paragraph describes procedures for importing output ASCII text file “methrXX.txt” into MS Access file “NBD_Pre
Processing.mdb”. The same or similar commands are applied for importing “metdayXX.txt” and “metrnXX.txt”.
Step D1: Open the MS Access file “NBD_Pre Processing.mdb”; consult paragraph 6.2 above to locate the appropriate
folder/directory path of the file, which is country-dependent. In table view, the following database window appear
The above view shows the 4 pre-defined tables as specified in table 4.
Step D2: Highlight the auxiliary table “Meteo_Hourly” and click “Open”. This results is illustrated in the following
screen: