Import Data from Excel or Text into the Aquifer Table
Borehole Manager | File | Import | Excel | Single Table | Aquifer Data
Borehole Manager | File | Import | Text | Single Table | Aquifer Data

These Borehole Manager programs are used to read row and column data from a single worksheet in Excel file or from a single text (CSV, tab-delimited) file, and import the rows and columns into the Aquifer table for a single borehole. This is primarily designed for users who have elevation or depth measurements for multiple units, which can't be easily brought into the RockWorks database using the Row Based Excel import. This import works with XLSX, XLS, CSV, and TXT files, provided that Microsoft Excel is installed on the user's machine.

Here is an example of the kind of data that can be brought into RockWorks using this program; this subset lists the borehole ID in the first column, and Aquifer names and depths in the subsequent columns.

! This program allows you to either append new data from Excel to existing aquifer data in RockWorks, or to replace all existing data.

Menu Options
Step-by-Step Summary

  1. Access the RockWorks Borehole Manager program tab.
  2. If necessary, browse to the project folder in which you want to work.
  3. Select the File | Import | CSV | Column Based | Aquifer menu option to import from CSV.
    Select the File | Import | Excel | Column Based | Aquifer menu option to import from XLS or XLSX.
  4. Select the name of the XLS or CSV file to be imported. The program will scan the file and load the names of the columns in the Input Column Name listing.
  5. Next, specify whether you are importing for a single borehole or for multiple holes using the Import for One Borehole checkbox (as described above).
  6. If you need to define the Aquifer names for your project boreholes (or add to existing names) click the Aquifer Type Table button and make the necessary changes to the Aquifer Type table.
  7. Map the project's Aquifers to the spreadsheet columns, as described above. Be sure to map the borehole name column to the Borehole ID field.
  8. Click the OK button to proceed.

The program will read the specified XLSX, XLS, CSV, or TXT file. It will extract the data from the requested data columns and map them to the indicated database fields for the indicated boreholes.

Back to Import Data

RockWare home page