Results of a benchmarking test. 20/08/2018

6,429 records. Col A to Col AL (some blank)

via Sheet row by row. Timer = 20.7 sec
via Array. Timer = 20.3 sec

Surprising result. I thought via Array would be a lot faster.

See folder C:\ExcelOMG Cookbook 2016\Upload to Access – array