PDA

View Full Version : Connections in MS Excel 2007



valchyshen
06-23-2008, 04:05 AM
Hi All,

How can I find out how many rows a connection returns. With a query it is quite simple. But with a connection I find it rather time-consuming to figure out. The problem is that PC has MS Excel 2007 installed. ...and it makes connections and not queries if one creates a quary to external database.

generally I would like to have a procedure that would run right after connection's requery process is done. How to do this?

Thank you very much for your help!

S