Hi All

I have a solution which I got help on in the "General" forum here.

Here are the details below. I wasn't able to pass over the variables but I created...

OK - thanks this all worked - a bit of tweaking but.... 🙂

I give the relevant code below

ASP code :

Request.Form("ExecuteLoad") = "SUBMIT" then

strsql = "exec SP1'" & Request.Form("Period_dbx")...

Thanks Ken but I am lost.....

Do you have a link to an explanation of those two please.

I will go down the above route first but I am eager to learn...

Thanks John - I was thinking that but how does the job pick up the details in the table

so Job would look something like:

SELECT @PERIOD = PERIOD_COL, @YEAR = YEAR_COL,...