I have seven data extracts from multiple systems which contain exactly the
same fields and I need to merge via a query into a single dataset. I
would
like to avoid the obvious of doing an im****t/append to create a single
table
because the data in the extracts frequently change.
Instead I wanted to create table links to each extract and then create a
query to merge the data. This way the single query dataset would update
with
the most recent records, without having to redo the entire im****t/append
process all over again to update the table.
Is this possible?
Thanks in advance for any assistence!!!
