Object to Recordset

LinkBack

Thread Tools

Search this Thread

November 12th, 2005, 06:10 PM

Felix

Guest

Posts: n/a

Object to Recordset

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

Bookmarks

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

What is Bytes?

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 220,662 network members.

Object to Recordset

Popular Articles

What is Bytes?