Parse information from 6 different MS-SQL databases, and create a custom Excel report.

When commercial software doesn't provide what you need, check out your local developers.

Code

After upgrading their MIS system, this private company realized there wasn't a way to create an easy-to-read report or display information in a format that they were used to. We developed a way to process the information from 6 different MS SQL servers, and parse it all in Excel using VBA. To maintain data integrity, all database operations are done as read only. The end user simply has to hit a refresh button to have instant access to all of the scheduling. Scheduling is presented in a nice, easy-to-read year-long calendar. Users also have the ability to enter a date, job number and a note in a separate sheet. When the schedule is generated from the databases, it also reads in the notes and places them appropriately in the schedule. Several coding techniques where used to ensure that jobs didn't overwrite other jobs (due to their run duration, custom notes or other various reasons), and to optimize sorting and building of the information in arrays.

  • Skills : VBA, SQL, Excel
  • Client:Confidential