Search results

I wanted to apply the same query to similar tables. One of my vendors send me files everyday. Same format, different data, but after I get those files I need to change them alittle bit for another program. so I was hoping to be able to use the same query on multiple tables when they come in

Is it possible to append an imported table or a linked table as soon as you bring it in?

I want to add excel spreadsheets to the tables and then use a query to filter them out Can I make one query and apply them to the different tables? Thanks