Importing Borehole Data from Another Database

Borehole Manager | File | Import | Database (e.g. acQuire, Newmont)

The program is used to import into the Borehole Manager a variety of well data from an external database. The process involves defining the data type and selecting the data file to be imported, mapping the import fields to the Borehole Manager fields, and importing the data, table-by-table.

Introduction
Step-by-Step Summary

Introduction

Some important notes about this import tool:

• This wizard imports table by table.  This is in contrast to the Excel import which gathers up all the information then does the import all at once. This tools' table-based approach gives you more control over the data that is imported and the sequence.  You only need to import the tables you want.
• If you import regularly from the same source or from a different source with a similar layout, you can save the import settings as a template for future use.
• The I-Data (assay) data can be imported in multiple passes since new data types can be appended to an existing I-Data table in RockWorks.

Acronyms

• MS – Microsoft
• OLEDB – Object Linking and Embedding, Database
• SQL – Structured Query Language
• UDL – Universal Data Link
• (see http://msdn2.microsoft.com/en-us/library/e38h511e(vs.71).aspx)

The following are the steps to import from an external database.

Step-by-Step Summary

• Step 1: Select the Data Source
• Step 2: Set up the Coordinate Information
• Step 3: Set up and Import Location Data
• Step 4: Set up and Import Survey Data
• Step 5: Set up and Import Bitmap Data
• Step 6: Set up and Import Color Data
• Step 7: Set up and Import Fracture Data
• Step 8: Set up and Import Assay (Interval) Data
• Step 9: Set up and Import I-Text Data
• Step 10: Set up and Import Lithology Data
• Step 11: Set up and Import Pattern Data
• Step 12: Set up and Import P-Data
• Step 13: Set up and Import P-Text
• Step 14: Set up and Import Stratigraphy
• Step 15: Set up and Import Downhole Symbols
• Step 16: Set up and Import T-Data
• Step 17: Set up and Import Vectors
• Step 18: Set up and Import Water Level Data
• Step 19: Set up and Import Well Construction Data
• Step 20: Save the Setup as a Template File

RockWare home page