Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stored Procedure call and passing parameters | Excel Programming | |||
execute stored procedure | Excel Programming | |||
Run a stored procedure in Excel 2K | Excel Programming | |||
Execute stored procedure using DAO | Excel Programming | |||
Passing parameter from Excel to stored procedure? | Excel Programming |