Greetings Experts. I really really need some help and guidance here. What I am trying to do is enable my users the ability to upload a spreadsheet to a specified directory. Once the spreadsheet has been uploaded, have a process that will read that spreadsheet and pull information from certain columns to a "Master" spreadsheet or an Access Database. The "Master" spreadsheet or Access database will be the collected data from each uploaded spreadsheet. Once the user has uploaded the spreadsheet and the data has been collected successfully, the uploaded file will be deleted to make room for the next user to upload. Please help!!
This will be in production with a department of 20 personnel. The Master sheet will be processed every 10 minutes or so into an Oracle database. I have the Oracle process already developed. As of now, my users have to manually process each spreadsheet; therefore, I am attempting to consolidate this and have the data validated before it gets pushed to the Oracle database. This will occur when the process runs every 10 minutes or so.
What is the best approach here? The spreadsheets that are uploaded to this directory are not setup identically. What I mean is that each column may be in different locations. Or there may be more data than needed. Is there a way that I can look for column headings and pull data based on that? Thank you everyone for your help with this.