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.
