Member Avatar for gurushankar

Hi All,

I am trying to copy recordset in excel file.

When i execute the query in toad it is obtaining 12 records.

But when i use ADODB.RecordSet it is returning only one record.

Please help me in fixing this..

Set objRec = CreateObject("ADODB.Recordset")
objRec.Open SQL, curSession

When i return the objRec and load it in excel file, it gives only the first record :(

Thanks,
Guru

  • 2 Contributors
  • 1 Reply
  • 57 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

how are you writing the record set to excel ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.