Datasheet

Data Retrieval, Processing and Final Storage in the Nile Basin Database

Data Processing in MS Access and Final Storage into the NBD

Step D11: Check “In an Existing Table:” and navigate in the related list box to the Meteo_Hourly table. Click

‘Next’.

This constitutes the final step in importing the ‘methrXX.txt’ ASCII file into the appropriate pre-defined MS Access

table. If no importing errors are encountered, the Text Import Wizard finishes the process by giving the following

message.

Step D12: Click OK.

The text file is now imported into the desired auxiliary MS Access table Meteo_Hourly. View the results by opening

the Meteo_Hourly table in the database window. Check on the integrity of data, in particular, the datalogger ID values

and make corrections if necessary. The result is presented on the screen given below: