March 26, 2002 at 12:28 pm
I have an Access application that runs a series of queries that end up by creating a table with a column of prospect id's called prspct_id. I would like to pass the prspct_id's as a parameter to a stored procedure that updates each prospects info in a SQL 7 database. I want to use ADO command object to do this. I can establish the connection to the SQL server, and execute the stored procedure but am struggling with passing the prospect id's to the procedure. Can someone help with the outline of how to pass the id's?
Thanks!!!!
March 26, 2002 at 1:49 pm
March 26, 2002 at 2:18 pm
Andy,
Thanks, this looks very helpful.
Jonathan
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply