Developer

Murray Brown

<div>
Hi. I want to find a way to pass parameters into an Excel SQL Query without using code.
</div>


Hi. I want to find a way to pass parameters into an Excel SQL Query without using code.

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
In Excel I managed to pull data through from my Azure SQL database. <br />
Is it possible to use variables in such a query?<br />
For instance I would like to have a from date and a to date that the user can change before<br />
the query is run. Is it possible to have such values in Excel cells?
</div>
</div>


Hi

In Excel I managed to pull data through from my Azure SQL database. 
Is it possible to use variables in such a query?
For instance I would like to have a from date and a to date that the user can change before
the query is run. Is it possible to have such values in Excel cells?

Excel SQL Database Query - using variables

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.

Azure

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.