Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import New Database Query (Union Query) in Spreadsheet | Excel Discussion (Misc queries) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |