I'm trying to execute a SQL stored procedure which takes a text parameter I would like to get from a field.

I've setup an import records script and pointed the ODBC to my SQL database OK but can't figure out the syntax for concatenating a text string to accept a parameter.

I want to do something like this:

"exec sp_findperson '" & ID Number & "'"

where ID Number is the field name.

Any suggestions?