I want a means of importing data from other people in my associati

[Guest]

This is probably a stupid question, but I am a novice! I am setting up an
organisation which will need to store various bits of information from its
members. I have designed an Access database to store their information,
which at the moment I have to enter from the information they enter on a
paper form. I was wondering if there is anyway I can email them some sort of
form, which they could fill in and email back and I can then review it before
importing it into my database. For example can I create an Excel spreadsheet
with cells I could link to the fields on my Access forms? Probably not.
What about a data access page? Or is there some other method?

 

[Guest]

a data access page implies that you have the resource to deal with web server
stuff....

an excel spread sheet will work fine. set one up and do an import to
yourself. (one key thing to remember is that all the column(field)
definitions need to correspond between excel and the access...)

you will have your table i.e Master Table

you will have an import table i.e. ImportTable - - for which everytime you
import an excel it will write over whatever prior import was once there....

And you will need an 'AppendQuery' that simply appends the ImportTable data
to the Master Table.