This blog describes how to have a live data connection from a gINT database into Excel. A similar process can be used to connect to an SQL-based gINT database.
The main benefit of this is being able to work in Excel with the latest data from your gINT database as the single source of truth for a project.
- Open Excel
- Go to Data tab > From Other Sources > From Microsoft Query
- Select MS Access Database*, and OK
- Set List Files of Type to All Files (*.*), and browse to "ags 3_1 rta 1_1 06.gpj"
- Under ISPT, select PointID, Depth and ISPT_NVAL
- Click Next
- Set order by PointID and Depth, select Next
- Select Finish
- Place it in the sheet where desired