I have multiple Access files with each one representing a sales account. They contain years worth of sales data stored in tables by sales periods (13 periods a year). Is there a way to have a generic query that will prompt you to select which table to use as it's source? If not, what alternatives are available. I currently am building a new query for each table I need to export as an Excel file.