pulseinfomatics.com
Passing a Variable Number of Parameters from MS Access to SQL Server
An example and source code demonstrating how to pass a variable number of parameters from MS Access to SQL Server. This also avoids the problem of strings with single (or double) quotes contained in the string.