Data Aquisition

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have 3 locations using the same database, each one inputs different records. What I would like to do is this. at the end of each day I would like to send an E-Mail to a 4th location where I would be able to compile the data and view it as needed. I would also need to archieve the data at the 4th location. I would just need certain tables from the database. Does anyone know how I could do this.
Thanks
DS
.