import aggregate data from databases in other offices

[traycee]

Hi!
I'm working on finding a simple inexpensive solution to aggregate data from multiple offices all of which use the same access database. We have 10 satellite offices running identical databases. Each office runs their own reports and sends these reports in, where we input them into a spreadsheet and then create aggregate totals with all of them together. Is there a way they could write that data to a floppy or email the data in a form so that the data could be appended to our database in this office and we could simply run the same reports but with all the data in one place?

 

[gwog]

Couldn't the satelite offices export data to excel (instead of "running reports"), then you could import excel sheets into your database and generate summary.

 

[traycee]

Thanks,
I thought of that, too. I just wasn't sure whether or not I was thinking in the right direction.

 

[BNPMike]

Access (both with Jet and MS SQL Server) features replication. This would seem a much more elegant solution to your situation.