@ NoSparks, xlnitwit, humdingaling
Quote Originally Posted by NoSparks View Post
Processor: Intel(R) Core(TM)2 Duo CPU E8400 @ 3.00GHz 3.00 GHz
4.00 GB (3.50 GB usable)
64-bit Windows 7 Pro
64-bit Excel 2010
Macro Sub USDAToDB()
_...
Code Errored! Code Description from Err Object is Application-defined or object-defined error
Code "bombed out" at Row 3595....
Quote Originally Posted by xlnitwit View Post
I ran your USDAToDBArrays routine to completion on Excel 2016 64bit. Win 10 64bit 8GB RAM.....
Quote Originally Posted by humdingaling View Post
...i think your just hitting the limit of excel memory
which is probably why the 64-bit Excel runs a lot more lines....
Quote Originally Posted by humdingaling View Post
....
Processor Intel(R) Core(TM) i7-5600U CPU @ 2.60GHz, 2601 Mhz, 2 Core(s), 4 Logical Processor(s)
Installed Physical Memory (RAM) 8.00 GB
64-bit Microsoft Windows 7 Enterprise
32-bit Excel 2010
Bombs out 232,......l
Quote Originally Posted by humdingaling View Post
....
I do believe the issue is excel limitations
which is probably the reason why the 64-bit excel versions have better luck running your code for longer
I have mostly 32 Bit computer and only 32 Bit Excel ... I can get some access to this...
http://imgur.com/cbuDZCE
That is a 64 Bit machine, but I only have 32 Bit Excel

So it would appear that we are saying , that, to get the improvement I need 64 Bit Excel. So in total I would need a large investment of both a new 64 Bit machine and a 64 Bt Excel. In addition I am sure I will have teething / compatibility problems etc.. etc... when I upgrade...

If I buy a new computer for example, it will have Windows 10. Then I can probably chuck away all my Printers etc... and look forward to a lot of other headaches as things no longer “work” lol.....

So for now I will investigate further how to improve my code / and or File..

Alan

P.s. @ xlnitwit
Quote Originally Posted by xlnitwit View Post
I ran your USDAToDBArrays routine to completion on Excel 2016 64bit. Win 10 64bit 8GB RAM.....
_...completion ???? - How far did you get? How many Rows ??? . Is it possible for you to get a copy of the “BDSept2016.xlsx” that You made to me ??
Thanks