Trying to run a query in the MPD File

[Biggles]

I get the following error message:

Run Time Error '-2147467259 (800004005)'
Method 'Execute' of object '_connection' failed.

I am trying to create a new table in the MPD file I created earlier with
this code:

ssql(19) = "TRANSFORM First(MSP_TEXT_FIELDS.TEXT_VALUE) AS FirstOfTEXT_VALUE
" & _
"SELECT MSP_TEXT_FIELDS.PROJ_ID, MSP_TEXT_FIELDS.TEXT_REF_UID
" & _
"INTO tblCT_TEXT_FIELDS " & _
"From MSP_TEXT_FIELDS " & _
"GROUP BY MSP_TEXT_FIELDS.PROJ_ID,
MSP_TEXT_FIELDS.TEXT_REF_UID " & _
"PIVOT MSP_TEXT_FIELDS.TEXT_FIELD_ID "

CONN_PROJ.Execute ssql(19)

I want to take the three different custom fields and have them on one line
so that I can use them together. Is this possible?