Importing Collar Data (XLS/Database Format)

When entering data in Drillhole, you must start with collar data. The system creates a unique collar database that you can use to view all drillholes in the project at a glance. You can also plot an initial plan map showing all holes for review purposes. A collar file must exist before survey or assay data can be imported, and before plans and sections can be created.

To Import Collar Data:

1. On the DH-Data menu click Import, and then click XLS/Database. The Drill Hole – Import XLS/Database dialog is displayed.

2. Using the browse button, select the file from your working directory and click the Open button. The system returns you to the Drill Hole – Import XLS/Database dialog box and displays the file name you wish to import.

3. The system scans the file and displays the first of two dialog boxes from the Drill Hole Import Wizard. Note that the system has determined that the Types of Data to import are Hole Collar Data.

4. The Drillhole Drill Hole Import Wizard enables you to easily import data from any table within a database. If you had multiple tables you would be able to select a specific table from the Database Table drop-down list. The Database Fields window (bottom left) displays the fields in the selected database.

4. Click the Next> button to display the second dialog box in the Drill Hole Import Wizard.

5. The Import Wizard has scanned your data and determined the Channel Type for each of the Database Fields. It is always good practice to review your data to ensure that the wizard has selected the correct columns.

6. The Data Type of Database Fields that contain alphanumeric data (for example, sample numbers, rockcodes etc.) must be classified as "String".

6. Click the Finish button. The system imports the collar data and displays it in the spreadsheet window.

7. At this point, we recommend that you examine the database table carefully. Start by confirming that all columns of data in the original file are present in the database.