SQL VBA builder

The SQL VBA builder lets you convert an SQL statement in a string you can use in VBA. Using the strSQL variable assembled in parts makes the code easier to read when it concerns multiple lines and helps you solve conflicts between any double quotes in your SQL and the qoutes surrounding the string.

For a good article on combining SQL and VBA click here

SQL_VBA_builder