I get a OUT OF VIRTUAL AND/OR LOGICAL MEMORY, allocating 2MB, message, how can I fix this?
This can have a number of causes. First of all, when loading data it is always good practice to drop temporary/staging tables as soon as you don't need them anymore. With large datasets, sometimes it is better to do calculations step by step, and not in one go. Try to use unique field names, because QV uses associative links based on identical fieldnames. This can lead to unexpected and undesired results. If all above fails, try fiddling with the following settings: