Datasheet

Microsoft Access
Edit
Vie..
Insert Tools
V.iridow Help
Ctrl+N
Ctr1+0
Get External Data
Close
Save
Save As...
Export._
Page Seti_jp...
aPrint Preview
Print... Ctrl+P
Send To
Database Properties
1 C: MyDbase '1,nbd'IJABD P.JEV.1 DATA
F
\ganud.'re. F
TocessinaVED_
F're ProcesSIng
2 C: \rylyDbase \ntid 1, Daily Hydro-Meteorological Data \D.A.:" Clim Uganda
3 CAMyDbase
1, Daily Hydro-Meteorological Data \Daily Clim Rwanda
4 CAMyDbase \nbd \Daily Hydro-Meteorological DataWb1
,1111111
Exit
Import...
+El Link Tables...
43
Manual
Data Processing in MS Access and Final Storage into the NBD
Step D5: Close Meteo_Hourly table.
The auxiliary Meteo_Hourly table is now empty. No data duplication will occur during data import process unless
the user imports a certain data set twice. Although this would eventually be refused by MS Access due to ‘key
violation’, it is recommended not to enter this situation. Continue with step D6.
Step D6: In the database window, select Get External Data from the File menu. Choose the sub command Import,
as presented below.
Step D7: In the subsequent window, navigate to the folder containing the Report output files and select the con-
cerned “methrXX.txt” file. Use the appropriate Windows Explorer operations. If the recommended directory structure
is used, “methrXX.txt” is stored in folder C:\CAMPBELL\FILES\OUTPUT. Make sure the ‘Files of type:’ box below-left
is set to Text Files. The resulting screen is depicted below: