VBA create a comma delimited string from Access table

[icyrius]

Hello all,

I need to create SQL pass-through query using a comma delimited string based on a long list of product IDs from an Access table.

In Excel, this was possible by transposing an array like this,

strProductID  = application.transpose (myarray)
strProductID = Join(strProductID, ",")

How can I accomplish this in Access?

This is the process I am working on,
1. run "select * from tableProductID"
2. transpose recordset (this does not work)
3. comma delimit recordset
4. store comma delimited recordset into a string variable
5. Plug variable into SQL pass-through string

Thank you for your help.

 

[james_lankford]

look at
recordset.getstring

it might do what you want