Hi

You can use Oracle transparent gateway for Sql Server to set up a link to your sql server 7/2000 database and schedule a Job to handle the process to push the data to Sql server.

If you are calling a COM object Iam sure Tim Hall's site has more Info on the process involved

http://www.oracle-base.com/

Regards,




[Edited by santoshym on 09-20-2002 at 07:49 PM]