Re: run SELECT SINGLE statement from Excel

[Javier Treviño]

Hi M Tilak,
What you need is very specific, and I believe it can be better achieved using VBA macros and MySQL Connector ODBC, so you can control exactly what you need.

In MySQL for Excel you could attempt to enable in the Global Options the one to preview queries before they are sent to the server, then edit the SELECT query the way you want and return to Excel exactly the rows you need.

However as I said before, I think it's less of a hassle to develop your own macro to do this, since using MySQL for Excel for that would make things rather manual and repetitive.

Best regards.

====================================
Javier Treviño
MySQL on Windows Team