Now the problem: Everything works nicely! BUT only maybe until attribute ~25. Then the loading times start to get horrendous. The script nearly needs ~8 hours to load. Then until everythin is loaded, the script works perfectly. We could pinpoint the problem. The problem is indeed in this concatentation of data. When we remove a couple of attributes it is very fast, if we load the full ~30 attributes, it gets super slow. What are we supposed to do? Any ideas how we can adjust our prgramming, so that is loads faster? We are really kind of out of ideas, since the programming seems to be not wrong, as it works fine after loading. But the loading itself is super time consuming.
Re: Very long loading times (8h) when adding just a couple of attributes (ACCESS+EXCEL)
The reason for the long loading times could be that there is not enough RAM available and the system swapped with the virtual RAM.
Beside them your load-snippets look a bit strange for me and there might be other more performant ways of doing what do you want to do - it's not really clear for me without the relevant parts of the script.