|
|
|
|
|
by amih
6130 days ago
|
|
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. keep focused!
Good luck! |
|