Help writing a query?

[omgjtt]

Help writing a query (sum of appends)?

Hello,

Every Monday I have to import 9 different files into a database. I then have to append each table from those 9 file to one table (leads)

The names of the imported file(s) change each week. I am wondering if there is a simple query I can write to make sure I have appended all 9 tables to the leads table.

Any feedback would be great.

Thanks

James

 

[omgjtt]

Sorry for making the title so non descriptive. I am unsure how to do this. I am guessing I will need to show unique values in a field?

Thanks in advance

James