Hi,

I'm new to excel and vba.

I have a web query which successfully returns data to a worksheet. I have it
refreshing every x minutes and it works fine.

Each refresh, I want to be able to update a database (Oracle) with the data
automatically.

Anyone have any examples/references of how I can do this?

The two ways I would like info on is:

1. Directly via excel.

2. By passing the data to another program to do the update.

I have a lot of MFC database code, so perhaps method 2 might be preferable,
although any info appreciated.

TIA