O
OnlyMe
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
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