MySQL Forums
Forum List  »  MySQL for Excel

Re: run query from excel with parameter
Posted by: Javier Treviño
Date: November 30, 2016 09:38AM

Hi Francisco,
Thanks for writing in our forums.
MySQL for Excel does not let you to visually design a query as part of the Import Data feature. You can see that you can select the columns to import but not play with the WHERE part of the query. This is as per design.

However, have you tried enabling in the Global Options the one to preview queries before they are sent to the server? That way you can simply edit the SELECT query the way you want and return to Excel exactly the rows you need.

Please let us know if that does the trick.

Best regards.

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: run query from excel with parameter
357
November 30, 2016 09:38AM


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.