I have made the connection of SQL and Excel and able to execute one query by goin in properties in Data connectiion.
What i need to know Can i run multiple queries in same excel[on same table] by making tabs and giving a button so that i can see desirable results to whatever tab i go .
I have not found any relevant material about this .
Please Do help .
Or let me know if i have to start from beginning for the result i desire .