View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
 
Posts: 441
Default 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.