Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Saving Array to Recordset/Table
Yes, the Test-DB is one single Access-DB with two Tables and one VBA-Module. I Access the Tables over "DAO 3.6 object library".- PieSchie
- Post #9
- Forum: Microsoft: Access Modules (VBA Coding)
-
Saving Array to Recordset/Table
So here it is :-/ I tried it on various systems. Still the same. AddNew is much faster. Sub RSWriteSpeed() Dim timer1 As Double Dim timer2 As Double Dim matrix() As Long Dim lb%, ub%, x% timer1 = 0 timer2 = 0 'Clear both Tables CurrentDb.Execute ("Delete * From Table1;")...- PieSchie
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
Saving Array to Recordset/Table
Thanks for replying but ... ... LBound and UBound as variables does no real speedup with my code. The "insert-into" Idea is great - I thought - but this is about 20 times slower than the addnew-thing. Is there no copy-paste-like function as if I would copy-paste some range from excel to a...- PieSchie
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Saving Array to Recordset/Table
Hello There, for performance-enhancement i am unsucsessfully looking for a complement of rs.getRows() to save data from array to a recordset/table without looping through the array, like for x LBound(myArray,2) to UBound(myArray,2) rs.addNew rs!value1 = myArray(0,x) rs!value2 =...- PieSchie
- Thread
- Replies: 15
- Forum: Microsoft: Access Modules (VBA Coding)
