Re: update records in excel file
From: Gerrit-Jan Linker <gjlinker_at_oraxcel.com>
Date: Sat, 23 Feb 2002 22:20:07 +0000 (UTC)
Message-ID: <a594in$9rg$1_at_paris.btinternet.com>
Date: Sat, 23 Feb 2002 22:20:07 +0000 (UTC)
Message-ID: <a594in$9rg$1_at_paris.btinternet.com>
I presume you could try to execute DDE commands connecting to the spreadsheet you want. You can use the Excel syntax: ActiveWorkbook.Worksheets("sheet1").Range("A1").Value = "new value" to change the values in the sheets.
Alternatively you could use SQL*XL to pull the data from Oracle from Excel and do it this way. SQL*XL specialises in interacting with Oracle from Excel. You can query Oracle and receive the info straight into the spreadsheet or upload a whole sheet full of data into Oracle. It's all neatly integrated into Excel. It even supports macro recording.
Have a look at SQL*XL at http://www.oraxcel.com Received on Sat Feb 23 2002 - 23:20:07 CET