Import Excel Data - Step 1

Step 1: Get ready and select the Excel file.

1. Create your Excel file. This can be made from scratch in Excel or it can be the result of exporting borehole data to Excel from RockWorks.
   ! See Excel File Format for details about the file’s structure.
   ! See the import scenarios to be sure you have the correct worksheets in your Excel file.
   
2. Start up RockWorks and access the Borehole Manager program tab.
   
3. Create a new project if necessary.
   
4. Select the File | Import | Excel | Row Based command.
   
5. You will be prompted whether you would like to create a backup version of your existing database - we generally recommend you answer Yes; click OK to confirm the automatic backup file name.
   
6. The program will display a dialog box where you will define the name of the file to import.

   

   
   
   • Import Filename: Click on the open-file button to the right of this prompt to browse for the Excel spreadsheet to be imported. This file does not need to be in the current project folder.
     
     If RockWorks was able to find worksheets that it can recognize, it will load them into the Block Selection tab. The next step is to define these (click the Next arrow below).
   • 
     
7. To continue, click the Next button at the bottom of the import window, or simply click on the Block Selection tab.
   

  Back to main topic     |     Next ( map the Excel worksheets ) 

RockWare home page