Connecting Tech Pros Worldwide Help | Site Map

Object to Recordset

Felix
Guest
 
Posts: n/a
#1: Nov 12 '05
Hi,

our SAP-System returns (via RFC-Call) a object (rows, columns).
Ich want the Data as a Recordset (Table) in Access.

My way (simplyfied) works - but slow!

For Each oRow In oData.Rows
iRow = iRow + 1
rs.AddNew
For iColumn = 1 To oFields.Rowcount
rs.Fields(iColumn) = " "
Next
rs.Update
Next oRow

How can I transfer the data of the object faster to
the recordset? Any idea ist welcome!

Regards
Felix

Ich hope you get what I mean. My school-english got somewhat rusty :-)
Closed Thread