MySQL Forums
Forum List  »  MySQL for Excel

Re: run SELECT SINGLE statement from Excel
Posted by: Javier Treviño
Date: November 30, 2016 09:48AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
1896
November 21, 2016 01:16PM
772
November 29, 2016 04:11PM
Re: run SELECT SINGLE statement from Excel
1117
November 30, 2016 09:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.