Hello all.
Currently I have a process that calls for 3 excel files that need to be merged and then used in a query.
I have them linked in access and create a union all query to combine and work their values as needed.
All this is fine until I am missing 1 or 2 of these excel files (they are generated automatically by a scheduled process).
Here the Union query doesn't run since it doesn't find the file (table).
How would I be able to write the sql in the Union query to use only those tables that exist?