Datasheet

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: