Sunday, January 23, 2005

The Easy Way to Parse Your MS Access SQL String for Insertion into Your Code

My MS Access Add-In and Wizard, Ezy SQL Editor & Builder, easily creates formatted SQL strings for your code. Ezy SQL automatically parses any SQL string, for example, from:

SELECT City, CompanyName, ContactName, "Customers" AS [Relationship] FROM Customers
UNION SELECT City, CompanyName, ContactName, "Suppliers"FROM SuppliersORDER BY City, CompanyName;

to:

strSQL = _
"SELECT City, CompanyName, ContactName, 'Customers' AS [Relationship] " & _
"FROM Customers " & _
"UNION " & _
"SELECT City, CompanyName, ContactName, 'Suppliers' " & _
"FROM Suppliers " & _
"ORDER BY City, CompanyName; "






No comments: