- Microsoft Query Parameter Cell Reference In Excel
- Excel Microsoft Query Parameter
- Access Query Parameter
- Microsoft Query Parameter Cell Reference Pdf
I'm using MS Excel to get data from a MySQL database through ODBC. I successfully get data using an SQL query. But now I want that query to be parameterized. So I wonder If it is possible to use a.
Active8 years ago
I have a sheet which uses a data connection to obtain data for a pivot table from an external database using a SQL query. The user can set parameters for the SQL by completing a few cells in the worksheet. The process is described here.
When I save and reload the file and refresh the data Excel crashes. I have found that the contents of the 'Get the value from the following cell:' field from the Parameters dialog box are not saved.
I have tried Excel 2007 and Excel 2010, saving in both XLSX and Binary formats but none of them save the setting. Does anyone have a fix or a workaround?
Arc rise fantasia gamefaqs. Screenshot of the dialog box is here:
Microsoft Query Parameter Cell Reference In Excel
Community♦
Robert BergsRobert Bergs
1 Answer
This problem comes when we want to 'import the data' directly into a 'PivotTable Report'.
Excel Microsoft Query Parameter
As a workaround'import the data' as 'Table' first in a separate sheet(say 'DB Data' sheet). Then build a pivot using this data in a separate sheet (say 'DB Pivot' sheet).
The parameters for the query (startdate etc.,) can be referenced from the 'DB Pivot' sheet. However, when the parameters change you have to refresh the table in 'DB Data' first and then the pivot.
To do it in with a single click, include a commandbutton(or a macro) with the following code.
Hope this helps.
SpicaSpica