Many files to one??
Many files to one??
(OP)
So here's the deal. I get emailed daily production from 9 wells, each is a separate file and each file gets renamed for each month/year. I take each of these 9 separate files, (soon to be quite a bit more) and have to take the past week's data from them and put it on another spreadsheet that I upload into a database to create my weekly report for the area. I'm just looking for any ideas on how I can make this easier on myself. 9 is not bad right now but 20, 30, 50... will be. Any imput would be very much appreciated. Thank You
Jake
Jake





RE: Many files to one??
But what is the point of the intermediate spreadsheet? I'm sure that you can query the incoming spreadsheets directly from the database.
RE: Many files to one??
You might try Tek-Tips.com, a sister site to this one where the computer geeks dwell.
RE: Many files to one??
David