Isn't it just possible to 'call' the Export command in Access so that it export a Table into another Access file?
I see that I could do so in two steps with the examples of these threads. But as I manipulate a large amount of information it becomes quite slow.