Running an SQL query on the open workbook

**someboddy** · 06-15-2010, 04:06 AM

How do I run an SQL query on the current open workbook? I know it's possible to save it into a file first and than open a connection to that file, but if possible I want to access the data on my sheets with SQL without saving them first.

**romperstomper** · 06-15-2010, 04:47 AM

Your workbook has to have been saved at some point or you can't connect to it. You should also be aware that there are memory leak issues if you use ADO to run SQL on the current workbook.

**someboddy** · 06-15-2010, 05:01 AM

That sucks. What can I use beside ADO?

**romperstomper** · 06-15-2010, 05:08 AM

You can use DAO but you still have to have saved the workbook. (I don't know if the same memory leaks occur with DAO to be honest, since I don't use it with Excel.)