I am trying to add the most efficient way to add a relatively high number of records to an MSAccess-table from excel vba
I used SQL Insert into queries, but I experienced performance issues, therefore I tried to use the update method of the RecordSet.
I noticed that there is an updateBatch method, and from the "batch" I make the conclusion that it is made for "mass upload", but I couldn't find any clear explanation, how does it work exactly.
I made some tests based on codes I found but I couldn't see differences in terms of speed, actually UpdateBatch is a little bit slower.
If somebody has any experience or knows any advantages of using updatebatch, I would appreciate if it would be shared with me.
Thank you