Import Drillhole Data from ODBC

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

    The Select Data Source window displays.

  2. Select the data source from:
    • File Data Source
    • Machine Data Source
  3. Click OK.

    The SQL Server Login window displays.

  4. Enter your Login ID and Password.
  5. Click OK.

    The Data Source - Select Tables window displays.

  6. Browse for and select the required tables.

    The Select Table Type window displays.

  7. Select the type of table being imported from:
    • Collars
    • Surveys
    • Assays
    • Lithology
  8. Click OK.

    The Drillhole Project Setup window displays the General tab.

  9. 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.
  10. Update the Depth / Length Units if required.
  11. Select whether the project contains Drillholes or Trenches (or both).
  12. Click Next.

    The Drillhole Location tab displays.

  13. Browse for and select the required Drilling Collar Table.
  14. Update the following fields in the Drilling Collar Table field group as required.
    • Collar Table
    • Hole ID
    • Easting
    • Northing
    • Elevation
    • Azimuth
    • Dip
    • Total Depth (Length)
  15. Browse for and select the required Drilling Survey Table.
  16. Update the following fields in the Drilling Survey Table field group as required.
    • Hole ID
    • Depth
    • Azimuth
    • Dip
  17. Select whether Down Dip is negative.
  18. Click Next.

    The Downhole tab displays.

  19. Browse for and select the required Downhole Tables.
  20. Click Add.
  21. Click Next.

    The Surfaces tab displays.

  22. Browse for and select the required Topographic file.
  23. Click Add.
  24. If there is Subterranean data, select the data and move it into the Selected section.
  25. If there is Surface Drape data, select the Polygon file and the Code used to identify the polygons.
  26. Select OK.
  27. Validate Imported Drillhole Data