| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of Stream Object
I am using Office 2003 on Windows XP.
Part 1) Can an ADO stream be used to port data, say from Oracle to Excel? Can it be used to transfer data from one Excel file to another? Part 2) Is there any advantage (overhead, speed, etc.) in using a stream over just a recordset? Is the stream really designed to be used for importing to/from web pages? Part 3) If all of this is favorable, can someone please post some example code that could be used to import data from Oracle, and an Excel file? Thanks much in advance for your assistance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use of Stream Object
See if this site helps:
http://www.dba-oracle.com/oracle_tip...preadsheet.htm "quartz" wrote: I am using Office 2003 on Windows XP. Part 1) Can an ADO stream be used to port data, say from Oracle to Excel? Can it be used to transfer data from one Excel file to another? Part 2) Is there any advantage (overhead, speed, etc.) in using a stream over just a recordset? Is the stream really designed to be used for importing to/from web pages? Part 3) If all of this is favorable, can someone please post some example code that could be used to import data from Oracle, and an Excel file? Thanks much in advance for your assistance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate IRR from a monthly income stream | Excel Discussion (Misc queries) | |||
| stream read error | Excel Discussion (Misc queries) | |||
| Data Stream Converter ?? | Excel Programming | |||
| How can I figure present value of a stream of payments? | New Users to Excel | |||
| Opening Excel with a stream | Excel Programming | |||
![quartz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
