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:
Post a Comment