• 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

    Huntley & Huntley 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 an SQL Server database, but other data were in Excel files and could not be tied into the geographical information, as they had no easy way for non-SQL users to access and edit the data. This resulted in out-of-date information and lots of frustration.

    “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,” said Rebecca Alcorn, GIS Manager at Huntley & Huntley, Inc. “This inhibited us from having a live link between our data tables and geographic data and led to out-of-date information and frustrations.”

    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 an SQL table,” continued Alcorn, “we found SQL Spreads was the most efficient and user-friendly option.”

    SQL Spreads uses Excel as an interface, while a conflict-detection system keeps the data accurate when people collaborate. Changes can be audited easily 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,” Alcorn stated, “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 centralized, up-to-date SQL Server database, while keeping the implementation and maintenance costs down (in terms of both time and money), 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,” concluded Alcorn.