Thanks for the suggestion, I will have a think about it.
The table names can be changed, you could click on the default letter name, 'A' for example, and rename it to SALES_NUMBERS for example.
I see the sense in using the worksheet name although there may be complications if there were multiple data regions on the same sheet or if the sheet name was long, as there isn't a huge amount of screen real-estate for the regions grid.
I like the idea, I sometimes need to work with excel and hate formulas and filters. I prefer sql and most of the time I don't export data from excel to a DB, I just grind my teeth and do some filtering and formulas in excel.
some remarks:
1. Perhaps you can let define the tables in the FROM clause like: FROM workbook1.xls~sheet2~A1:D4 AS table1
2. Add an option to autohide the not selected rows instead of coloring the selected rows, this will give a condensed result set that the user can maybe copy and paste to another sheet.
3. Don't worry about Microsoft competing - they might offer to buy you out.
The table names can be changed, you could click on the default letter name, 'A' for example, and rename it to SALES_NUMBERS for example.
I see the sense in using the worksheet name although there may be complications if there were multiple data regions on the same sheet or if the sheet name was long, as there isn't a huge amount of screen real-estate for the regions grid.
Thanks for the food for thought.