Make table query questions

[JoeA2006]

I have designed a database that imports data from an external data source and
also accepts user inputted data. Sometimes records from both the data sources
may have to be modified. I have to create several multi-table queries to get
the data normalized and to be able to produce a report . I created a union
between the queries with manually entered data and the external data. I then
run a make table query against that union query. I then run another set of
queries against the new table to sort and categorize the data for proper
placement on the report. Of course any modifications I make to the final
table get's overwritten the next time I run a make table query. My changes to
the manual data are saved because I am changing the data in the original
table. Its only the external data that I can't decide how to save
modifications. If I change the data in the original table I imported, it does
not get over written, but that data means nothing to user until I create the
queries with other tables.

 

[JoeA2006]

I think I need to just append the new data (after all the queries are run)
from the external data source to a master table that I can write to. I don't
think there would be a need for a make- table query. The appends would not
over write the data already written in the master table. All I need from the
imported table are the newest records. Does that sound better?