I'm a sailor over here in Afghanistan awash in a sea of data! I've written an Access dbase to manage the data and am using a standardized Excel spreadsheet form to update the dbase with new info that comes in daily. I need to figure out a way to automate as much of the input file management as I can so that when I (and my programming skills) leave, the data flow is automated as much as possible.
I will receive daily maintenance request info from 16 forward bases via a standard spreadsheet form. Each request will be submitted via email as seperate spreadsheet. Attached is a schematic of the dataflow.
From an Access dbase form, I need to automatically merge (append) each day's request (record) from each base into a single master spreadsheet. The Access dbase will be linked to this master spreadsheet.