Passing an array or recordset to a stored procedure
 

There is a solution I use for a similar problem, but it may not be optimal
since we are using a 3 tier architecture through a web server. This is to
create a recordset at the client containing the equivalent of your array,
upload the recordset into an empty table at the database, then have the
stored proc access the table using a cursor to work through the record and
do any processing. You don't mention what the stored proc does, so difficult
to say if this would work for you.

Robin Hammond
www.enhanceddatasystems.com

"Raul" wrote in message
...
I need to pass an array of data to a stored procedure
that will evaluate the data and insert it into the
database. I have created a VBA routine that generates
the array. I have also written a stored procedure using
local variables that does what I need to on the database
side. Now I need some help figuring out how pass the
data to the stored procedure.

Any suggestions?

Thanks,
Raul

Passing an array or recordset to a stored procedure
 

Robin,
Creating the recordset and uploading it to a table what I would like to do;
working out the issuses is the hard part.

Thanks,
Raul

"Robin Hammond" wrote:

There is a solution I use for a similar problem, but it may not be optimal
since we are using a 3 tier architecture through a web server. This is to
create a recordset at the client containing the equivalent of your array,
upload the recordset into an empty table at the database, then have the
stored proc access the table using a cursor to work through the record and
do any processing. You don't mention what the stored proc does, so difficult
to say if this would work for you.

Robin Hammond
www.enhanceddatasystems.com

"Raul" wrote in message
...
I need to pass an array of data to a stored procedure
that will evaluate the data and insert it into the
database. I have created a VBA routine that generates
the array. I have also written a stored procedure using
local variables that does what I need to on the database
side. Now I need some help figuring out how pass the
data to the stored procedure.

Any suggestions?

Thanks,
Raul