Seequent Civil and Environmental Customer Solutions Specialist, Gary Johnson, works out of our Denver, Colorado office. Spending much of his time assisting with customer support, he has come across a number of questions regarding gINT imports via an ODBC data source and Microsoft Access. This article is a simple How To for those who utilize these databases to store data.
How to Import Borehole Data from an ODBC Database (gINT, MS Access, Excel Files) into Leapfrog Works.
Handy tip: Always ensure that the 64-bit version of Microsoft Access is downloaded on your computer if applicable.
Importing from an ODBC Data Source or an Open Database Connectivity (ODBC)
To import borehole data directly from any database that uses an ODBC interface, right-click on the Borehole Data folder and select Import Borehole Data via ODBC. The Select ODBC Data Source window will appear:
In order to import anything via a Microsoft Access Database, the 64-bit Version of Microsoft Access must be installed on the computer
Leapfrog Works supports database files in Access Database (*.mdb, *.accdb), gINT Project (*.gpj), and Excel file formats.
1) Selecting Database:
You will have the option to select an ODBC data source or a Database file to import your borehole data.
Selecting ODBC data source will give you the option to select Excel Files or a MS Access Database.
Selecting Database file will enable you to locate the files on your computer and allow you to designate them as Access Database (*.mdb, *.accdb), gINT Project (*.gpj), or Excel files.
You will then be prompted to enter the authentication information supplied by your database administrator or Login using windows credentials if applicable and click OK.
3) Selecting Tables:
Leapfrog Works will select the collar, survey and interval tables from the data in the file, which is displayed in the Select Tables to Import window:
Click on the Collar Table, Survey Table and Screen Table dropdown lists to select from the data available in the file.
To change one of the ‘Interval Tables’ to a different column in the file, click on the table name to highlight it, then click to the right of the column name to activate the dropdown list:
To remove an interval table from the list, click the – button.
To add an interval table, click the Add Interval Table button. A – button will be added to the Interval Tables list.
Click on the blank space to highlight it, then click to the right of the column name to activate the dropdown list:
Click OK to begin the process of importing the data, which is similar to the process of importing boreholes normally.
Support when you need it:
Seequent offers a wide range of support options to our customers so that you can get help when you need it. Our Customer Solutions Specialist team can be contacted anytime on [email protected] or we have intuitive online training options available on my.leapfrog3d.com/training.
Has this ‘How To’ article been helpful for you? Is there something you would like to see covered? Leave a comment or send an email to [email protected]. We would love to hear from you.