Thanks Larry ... *excellent* idea. We're on SQL2K, so I'll try it and see how quick I can get it to work in this case. I *really* appreciate the fast response on this one...

Evan


>Evan,
>Depending on what version of SQL Server you're using, you can create XML from the RecordSet object and pass that to your SQL Server SP. You can then use the T-SQL OpenXML function to open it and access it as you would any table/view. This is available in SQL Server 2000.
>
>See MSDN documentation on Save method of RecordSet object for XML stuff and see SQL Server BOL for help on OpenXML.
>
>HTH.
>
>>Hi gang,
>>
>>This one's important, and I need a solution *fast*.
>>
>>I have an ADO recordset, containing new data. I need to *pass* this recordset, from a VFP COM object I've created, to a SQL stored procedure, which will INSERT these rows into a single SQL table.
>>
>>How the (expletive deleted) do I pass this recordset so that the stored procedure can see it, recognize that it's an ADO recordset, and insert the rows? Or, alternately, should I maybe spin through the recordset and build an array to pass instead of the recordset -- but then, doesn't COMARRAY() get its ugly head into the mix?
>>
>>Using remote views or SPT is not an option, BTW (it's a LONG story, don't ask)(g)
>>
>>(Aside: I'll also be sending a different recordset to UPDATE rows, but I think if I can get the INSERT, I can figure out the UPDATE part.)
>>
>>*ANY* help is -greatly- appreciated, since I'm under the gun on this one.
>>
>>TIA,