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!!!!