A delivery company had all their route information stored on hundreds of Excel spreadsheets. We needed to capture this business-critical data and convert over to a new Access database we designed.  Manually entering the data would take weeks and be prone to errors.

We developed a macro to sweep in all the route spreadsheets, convert to a common data format, and load directly to the new database.