Datasheet

Import Text Wizard
You can store your data in a new table or in an existing table,
lyVhere would you like to store your data?
C In a Nev.) Table
6. In an Existing Table:
ID Converter
Meteo_5rninRain
Ad±anced...
CanCel
BackI
Next
5 2001 ; 5 1500 27.54 2.253 1.429 2.782 1.388
5 2001 35 1600 25.86 2.239 1.095 1.423 1.38
5 2001 35 1700 25.76 2.222 1.094 .94 1.244
5 2001 351600160n 24.41 2.137 .921 .294
1.04
5 2 n01 =.1
5 1q0n 23.n5 7. 1E;5
.534
.044
.47
5 2001 35 2000 21.6
2.179 .4
D
.48
46
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: