MySQL Forums
Forum List  »  MySQL for Excel

Embeded Queries
Posted by: Peter Riggs
Date: March 20, 2013 02:43AM

I have an Excel sheet that has around 40 embeded mysql queries, and each one produces a table that is determined by two dates. Currently, if the date range needs to be changed, I have to edit each query individually. What I want to do, if have the queries reference two cells in the Excel spreadsheet so that I can put in the 'TO DATE' in Cell A1 and the 'FROM DATE' in cell A2 and the query then references those fields.
Is this possible?

Options: ReplyQuote

Written By
Embeded Queries
March 20, 2013 02:43AM

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.