Tips for Appending Data

The following list includes some strategies for appending data:
  • Design a query to load the baseline data to the output table and run it.
  • Modify the query, or use Save As to create an identical query and modify that one.
  • Select the Append data check box.
  • Add a filter on the Where or Having tab to select the changed data.
  • Schedule the query.