• banner

    “The PCA crew is leagues above
    the competition” - Pepsico

  • "a prior vendor failed to develop
    the application, which (Practical) delivered." - Franklin Park

  • "the application (is) easier to use, with a
    much simpler, more intuitive use interface" - Royal Administration Services

  • "Sometimes it's the things you don't ask for
    that are important" - Royal Administration Services

  • "PCA turned our raw data and algorithms into easy to use
    and understand features and reports." - CareScout

  • "The quality and professionalism ... has been
    so outstanding that we want to send you a letter of thanks." - USALCO

  • "PCA people and applications stand out by
    far exceeding our expectations." - USALCO

  • "The resulting application greatly increas(ed)...
    our business effectiveness and efficiency." - The Advest Group

  • "PCA completes projects
    efficiently and effectively" - Pepsico

Excel to SQL Server Migration

Practical Computer Applications can make your MS Excel application more structured, while preserving the original functional integrity of the original MS Excel spreadsheet.  As a matter of fact, your data can still be viewed, exported, and analyzed in MS Excel.

After converting to an MS SQL Server database, your data will be more reliable and manageable.  All of the data input, equations, and data manipulation becomes part of a structured, well-defined database application, which provides for improved data entry consistency, improved versioning as new capabilities get added, and generally easier, more straight forward user interfaces.  Best of all, the data can be controlled and made available through secure ole-based security over the Internet.

Benefits of MS Excel vs. MS SQL Server

MS Excel SQL Server
Workflow None (Email) Process-flow defined
Concurrent Updates No (One User At A Time) Yes (Multiple, concurrent Users)
Security Low. One password fits all. High. Role-based privileges.
Version Issues High Risk (file data stamp) None. Full Control.
Audit-ability Low (date and email comparisons) High (full audit trail)
Data Integrity Low (somewhat constrained) Highly constrained
Data Capacity Limited Unlimited
Data Structures Flat: 2-dimensions Relational: 3-dimensions

Once an Excel application has been converted to a SQL Server Database, the data can still be viewed, exported, and analyzed in MS Excel. All of the data input, equations, and data manipulation becomes part of a structured, well-defined database application. The new application provides for improved data entry consistency improved version control, and an easier, more straightforward user interface. Best of all, the data can be controlled and made available through secure role-based security over the Internet.