Object to Recordset

November 12th, 2005, 07:10 PM

Felix

Guest

Posts: n/a

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 :-)

« previous question | next question »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert Dataset to Recordset in C#	Marathoner	answers	9	November 16th, 2005 05:56 PM
how to pass recordset object to procedures/functions?	JingleBEV	answers	3	November 13th, 2005 01:52 AM
Classic ASP to .NET WebService interfacing (Dataset to RecordSet)	Adam Short	answers	19	July 22nd, 2005 03:02 AM
how to pass recordset object to procedures/functions?	JingleBEV	answers	2	July 17th, 2005 10:04 PM

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 225,662 network members.