Collecting data from different sources using Access

[studor63]

Hi!
So I have a bit of an issue that I would like to solve using Access, but I don't even know if it's possible - could somebody clarify for me? I am working on a project where I have data coming in from about 70 different sources across my state... but right now, they're all submitting their data in different ways (some through websites, some through databases, and some through excel spreadsheets they send monthly). As you can imagine, this is a nightmare for trying to get all of the data in one place to do some statistics on.

My question is this - if I were to set up an Access form where each client could fill in the blanks with the same information they've been submitting to all these other sources, could I send it out to them and have it all compile in one place? The last place I worked, we used Access to manage all of our on-site stuff, but we were all on the same network. Could it work the same way if everyone is spread across one state?

Thanks,


Very hopefull this will work!

[June7]

If you send everyone an Access file to enter records and return then you will have to develop an import procedure to pull the data into the 'master' file.

Check out the Collect Data functionality of Access.

Sharepoint might be another option.