Best Fit Users
What's Included
Technical Details

Program Conversion - Microsoft Excel

Many organizations solve information management problems with improvised solutions.  It is quite common to go into a marketing department or other 'orphaned' working group and find a very complicated data managment system implemented entirely in Microsoft Excel or a similar spreadsheet.  The term 'orphaned' in this case refers to IT development priorities: while the services of the group may be critical to organization success, programming resources are entirely committed to handling accounting, order entry, and other processes that would shut off revenue immediately were they to stop.

Many of these spreadsheets are pure 'row and column', where the name of the column is on row 1 and the data rows range from 2 onwards.  Another style is more like the 'expense report', which cells alternate from labels to variables reading from left to right, and a 'record' takes up a sheet, rather than a row.

We have developed an automation tool that can generate a Windows Forms/C#/SQL Server table maintenance application directly from the row/column spreadsheet special case.  There are certain restructions and assumptions.  Without further customization, the table is assumed to be all text fields (numeric or date formats are not treated as their respective formats).  The tool does not import any data, althought that can be done in a separate step.  There is no security setting, although again that can be provided as a customization option.  This conversion system does not convert Excel Macros, the implementation of those or other business rules has to be addressed separately.

For users that are running into limits, particularly with shared access or concurrent data entry, this conversion system gives users the ability to share their on-line records and workload with up to five people with the 'free' version of SQL Server Express, and 60 or more users with a SQL Server Standard Edition deployment.  This program is easily migrated to any data source that interfaces with ODBC, including, for example: DB2, Oracle, MySQL, and PostGreSQL.

An ASP.NET (web based) version is also available, although this involves more post migration coding modifications.

For those that feel it would be nice to have a 'real' business application rather than a collection of records being maintained in a spreadsheet, please call 210-734-5575 for free initial consultation.

Or, eMail us at