LISTING 2: Example Code That Populates
 the Geology Dimension Table

INSERT  tblSamplingDescriptionDimension
( tblSamplingDescriptionDimension.SampleID,
 tblSamplingDescriptionDimension.Device,
 tblSamplingDescriptionDimension.CoreLengthInCm,
 tblSamplingDescriptionDimension.CoreCondition)
SELECT
conmar05A.SampleID, conmar05A.Device, 
conmar05A.CoreLengthInCm,  conmar05A.CoreCondition
FROM Conmar05A