Hi folks,
I was working on a project today where i have made my work book as a sql database,purely saying a sql database table where i ran sql queries against my excel data.It was amaged to see the capabilities of VBA|excel.

i will surely explain my experience to you on how i did it.