Union Query using linked table drops records

[John Masui]

I am adding 5 excel linked table to create one
consolidated query using union feature but it seems to
pick up only unique records. If the fields are the same I
guess Access drops it as if they are duplicate records.

Is there a way to combine two or more tables without
dropping any records even if its not unique?

 

[Kent Prokopy]

Try this:

select * from t1
union all select * from t2