Import Drillhole Data from an Access Database

1. On the Discover ribbon tab, in the Drillhole Project group, expand Import Drillhole and click Import Access.

   The Drillhole Project Setup window displays the General tab.

2. To change the coordinate reference system (CRS):
   1. Click the button next to CRS.

      The Pick a Coordinate System window displays the XY Coordinate Systems Available.

   2. Select the required coordinate system.
   3. Click OK.
3. Update the Depth / Length Units if required.
4. Select whether the project contains Drillholes or Trenches (or both).
5. Click Next.

   The ACCDB Import tab displays.

6. Browse for and select the required .accdb file.
7. Update the following fields in the Collar Table field group as required.
   • Collar Table
   • Hole ID
   • Easting
   • Northing
   • Elevation
   • Azimuth
   • Dip
   • Total Depth (Length)
8. Update the following fields in the Survey Table field group as required.
   • Hole ID
   • Depth
   • Azimuth
   • Dip
9. Select whether Down Dip is negative.
10. Click Next.

    The Downhole tab displays.

11. Browse for and select the required Downhole Tables.
12. Click Add.
13. Click Next.

    The Surfaces tab displays.

14. Browse for and select the required Topographic file.
15. Click Add.
16. If there is Subterranean data, select the data and move it into the Selected section.
17. If there is Surface Drape data, select the Polygon file and the Code is used to identify the polygons.
18. Click OK.
19. Validate Imported Drillhole Data.