Web Query to database
 

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

Web Query to database
 

I am downloading stock quotes in a master sheet which is dynamic inthes
sense it is hanging erasing old quotes

But I would liketo the progress of the quotes. so I have a customised vba
programme which parks the latest data in a second sheet for those stocks I
am interested in . I can send you the programme and you can modify it. may
be my programme is not elegant.

you send an email message
remove $,@,& from my email address.

OnlyMe wrote in message
...
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