I have never done an Append Query - Can you give me some direction?

Thank you,

"Bill Manville" wrote in message
...
Jwrnana wrote:
Once I receive this back, is there a way to pull the data back to access
via
excel?


You will generally need to run a query of some sort to update the
database.
Depending on the structure of the data you need to import.
- If it is in a columnar table, I would import the table into Access and
then
run an Append query in Access to add the data to the master tables.

- If it is distributed in different cells then I would construct an Append
query in a VBA macro and have that executed.


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup