M
marta
Hello,
I have a database to which a number of people contribute
data. Because I am the only one in the group that has
Access, they submit the data to me in Excel form and then
I transfer it using the Paste Append method. It would be
a great time saver to be able to automate this process.
Do you have any advise on how to best automate the data
entry process?
My limitations are these:
-I will be the only one with access to Access
-People contributing data will have access to excel as
their data entry interface
-The data entry form has to be simple and easy to
understand
-I will need to review the data before it is saved in its
final destination table
I really appreciate your advise
thanks in advance
Marta
I have a database to which a number of people contribute
data. Because I am the only one in the group that has
Access, they submit the data to me in Excel form and then
I transfer it using the Paste Append method. It would be
a great time saver to be able to automate this process.
Do you have any advise on how to best automate the data
entry process?
My limitations are these:
-I will be the only one with access to Access
-People contributing data will have access to excel as
their data entry interface
-The data entry form has to be simple and easy to
understand
-I will need to review the data before it is saved in its
final destination table
I really appreciate your advise
thanks in advance
Marta