Loading analyte results to the Geochemistry Database using the MS ACCESS LOADER application

MacKenzie, A.C.; Johnson, C.C.. 2006 Loading analyte results to the Geochemistry Database using the MS ACCESS LOADER application. Nottingham, UK, British Geological Survey, 45pp. (IR/06/097) (Unpublished)

Before downloading, please read NORA policies.

Download (455kB)
Official URL:


LOADER is a MS ACCESS application to assist the bulk loading of sample site and analytical data, written specifically for the G-BASE (Geochemical Baseline Survey of the Environment) project but it is also applicable to the bulk loading of any inorganic geochemical sample data. This report does not cover the bulk loading of site information as this is reported elsewhere. It covers the bulk loading of inorganic analytical analyses to Oracle data tables of the British Geological Survey’s (BGS) Geochemistry Database. The process of loading the data consists of three stages. Firstly, the data provider is required to format the data in an MS EXCEL worksheet to a layout specified in this report. Secondly, the data provider submits a request to load or update data to the Geochemistry Database Data Manager. An important part of this process is that the data provider must sign off the data as having been loaded correctly. Finally, the LOADER application is run to load data to the relevant Oracle data tables. This final stage can only be undertaken by Oracle users with ‘access’ and ‘write’ permissions so most data providers will not be involved in this stage. Details of the LOADER application are included in the report so the complete process of loading the data can be understood. Raw data can now be transferred direct into raw data tables of the Geochemistry Database via the BGS Laboratory Information Management System (LIMS) but there is still a requirement to bulk load conditioned data (i.e. data that has undergone a number of QA/QC and levelling procedures) and capture legacy raw and conditioned data not yet entered into the database.

Item Type: Publication - Report
Programmes: BGS Programmes > Information Management
Funders/Sponsors: NERC
Additional Information. Not used in RCUK Gateway to Research.: This item has been internally reviewed but not externally peer-reviewed
Additional Keywords: Databases, Geochemistry
NORA Subject Terms: Earth Sciences
Date made live: 05 Jun 2009 10:49 +0 (UTC)

Actions (login required)

View Item View Item

Document Downloads

Downloads for past 30 days

Downloads per month over past year

More statistics for this item...