Hi !
Thanks very much for the suggestions. These are both really good. We do have number 1 in the list already. The 2nd suggestion is great too - thank you. I am hoping to get some movement on the next release soon. For the past while I have not had too much time.
For the issue with the embedded query I would first check to make sure the problem is not workbook specific.
IF you still have a problem in an empty workbook. Then I would try to use MS Query to embed the query. If MS Query fails too then there is a general type of issue (maye part of the mdac installation
How to check for MDAC version).
If you can use MS Query but can't use SQL Drill - then please could you send me the full error.
One other thing is that - if you can try the same on a different machine that you can get access on... Basically check if is machine specific..
Please let me know how it goes and I will do my best to help. Also, thanks alot for the suggestions.