Thread: owc next version must support datasets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default owc next version must support datasets
Send requests to:



--
Regards,
Tom Ogilvy


"Sarfraz Ahmed" wrote in message
...
what i have discovered is that owc9 dont support recordsets while owc11
support recordsets

' owc9
objPivotTable.DataSource =objRS

'this give error : Class does not support Automation or does not support
expected interface
But above line of code works fine if owc11 is used.

it means OWC11 is capable of accepting Recordsets as datasource whil owc9
is
not.

while following code doesnt work for any of owc9 and owc11


objPivotTable.DataSource =objDataSet '' doesnt work for b


so i think next version of owc can be made capable of accepeting Datasets
as
datasource as well.


Reply With QuoteReply With Quote