Many files to one??

[jackosieves]

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

 

[MintJulep]

MS Query.

But what is the point of the intermediate spreadsheet? I'm sure that you can query the incoming spreadsheets directly from the database.

 

[MiketheEngineer]

You might have to write a VBA routine to "add" all the data together or whatever you need.

You might try Tek-Tips.com, a sister site to this one where the computer geeks dwell.

 

[zdas04]

I don't understand the intermediate spreadsheet either. I'd just use the External Data option in Access and append the files to your production table. You could put all the files in a folder by month and write a VBA routine to suck them all in in a batch job.

David