Need a bit of help or a nudge in the right the direction. I manage a website for the Search and Rescue team i'm on and on this we list our callouts for the year. Well it now looks like that the national body wants to use a similar site and would like me to get all the team sites feeding their callouts data into one main callout list.
The main question is how do i do it :o)
Ok each site has it's own database and dataset i need to pull that data and display in one list, do i create a table on the main site that pulls the information on a scheduled basis or do i just run query's and merger the data at that point with no permanent table but could that end up being too slow. Also i'm not sure how to merge data or even for that matter getting a scheduled import of data into a table.
Any help pointers code greatly appreciated.