Blog

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

 

Comments

Guest
2:04:16 AM Monday, 16 November 2015

loans with bad credit <a href=http://payday100loans24online.com/>pay day loans</a>
payday loan <a href="http://payday100loans24online.com/"> online payday loans</a>

Guest
2:04:16 AM Monday, 16 November 2015

payday loans online <a href=http://payday100loans24online.com/>payday loans online</a>
personal loans <a href="http://payday100loans24online.com/"> personal loan</a>

Leave your comment