2:04:16 AM Monday, 16 November 2015

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.

  1. Open Excel
  2. Go to Data tab > From Other Sources > From Microsoft Query
  3. Select MS Access Database*, and OK
  4. Set List Files of Type to All Files (*.*), and browse to "ags 3_1 rta 1_1 06.gpj"
  5. Under ISPT, select PointID, Depth and ISPT_NVAL
  6. Click Next
  7. Set order by PointID and Depth, select Next
  8. Select Finish
  9. Place it in the sheet where desired


Leave your comment