hello,

I have to write a program that will run 7 days per week at 9.00pm and append the data to the 3 tables in SQL 2000.
Now i am not sure how to go about it.
I am at lost how to go about it using VB6.0
and write a stored proc tht will run 7 days per week at 9.00pm and also append to the 3 tables?
Pls can someone guide me and give a similar sample code?

If it just the SQL Server Stored Procedure that you ened to automate then you can use the scheduler in SQL Server to do this for you. If you must use a VB program then there are plenty of schedulers in Windows (such as AT or WINAT) that will do the scheduling for you.