• Application was sent! You’ll get a confirmation email soon.

    Read this case study to see how one company used Excel to manage their SQL Server data.

    Situation

    Huntely & Huntely is a US-based geologic and engineering consulting firm for the oil and natural gas industry, working with a lot of information that depends on geographical information.

    They had all the geographical information in a SQL Server database, but other data was in Excel files and could not easily be tied into the geographical information as they had no easy way for non-SQL users to access and edit the data. This led to out of date information and frustrations.

    ”Ideally, the data tied to our geographic information would have been stored in tables on our internal SQL server as well, however, prior to purchasing SQL Spreads, we had no interface for users who worked outside of the SQL Server/database to access and edit information. This inhibited us from having a live link between our data tables and geographic data and led to out of date information and frustrations.” says Rebecca Alcorn, GIS Manager at Huntley & Huntley, Inc.

    Solution

    SQL Spreads is an Excel Add-In where non-technical people can update SQL server databases easily using Excel. They can update databases with internal relations (foreign key relations) and use formulas to calculate values in the database without extra steps.

    “In searching for a cost-effective way to enable non-SQL users to access and edit data stored in a SQL table, we found SQL Spreads was the most efficient and user-friendly option.”

    SQL Spreads use Excel as an interface and a conflict-detection system keeps the data accurate when people collaborate. Changes can also easily be audited to see who changed what and when.

    “End users are still interfaced with a table very similar to the Excel table they had been accustomed to, but it enabled multiple members of our administrative team to update information at the same time and now link directly into our SQL server and geographic information. “

    SQL Spreads will help to keep all the data in a central up-to-date SQL Server database, but still the implementation and maintenance are cheap and fast as there is no need for coding or extensive training.

    “The time and cost of implementing SQL Spreads was much more efficient than purchasing or building an elaborate custom interface.“ states Alcorn.