An Access table or db has a 2 GB limit, including overhead, so with 8 million recs, you may be there already. Or soon would be. Obviously depends on the number of fields and their data types. Slowness is sometimes due to lack of indexing, but you probably cannot alter the indexes on the source tables. Performing aggregate functions on such large data sets also contributes to slow performance. Having multiple back ends might be your only option if you must import the data.
Last edited by Micron; 04-07-2018 at 03:05 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.