Ok, I'm trying to write a query in a stored procedure in SQL Server 2000. Because some of the parts of the query vary based on certain situations I construct a string that contains the query and ...

Improve this page Add a description, image, and links to the query-string-builder topic page so that developers can more easily learn about it.

Object-Based Database Interaction for VBA Easily create SQL queries and execute them on a database. For an example on how to use this library with data objects, see the VBA-Drupal-Library. For other ...

VBA: Connection string results in "External table is not in the expected format" arthur barnhouse May 2, 2014 Jump to latest Follow Reply ...

Today’s author is Mike Alexander, an Excel MVP who shows us how to run a Stored Procedure to get data from a SQL server. We all know we can use MS Query to get data from a SQL server. Typically though ...

Don't struggle to pass strings. Instead, apply these five simple rules when working with embedded strings in VBA.