I found a commandline app called DavCopy which will upload a file to a
document list - which would fulfill part of my proposed process. But to explain
better, we have an offline MS Access database which we use as our main source of
information for contacts. We have a few associates who are outside our house
and do not have access to this database. We don't want to put our network
online either. So, I am thinking that we can at least post the part of the
contact info which they need - as a spreadsheet or excel document, so they could
at least have current information.
The problem is if they want to update that document. There isn't any
no-hands-involved way of getting that back into our main database.
What we would need is a way for access to check for changes to that excel
document and to import the changes if it finds them. Also, access would need to
periodically export a new list when changes are made to our main database. The
effect would be like having a portion of our database online - but not really.
Clear as mud?