Hey @alexloudon - I've not come across this myself - but an approach to tackle this would be to tackle this as a single-file solution (i.e. get this running for 1 file) and then wrap this in a batch macro and run this once per file?
If this doesn't work - I'd probably revert to:
- Negotiate with the data providers to give me a DB connection to point to
- if this doesn't work, can they put this data on a network path instead
- if this doesn't work, is there a possibility to automate moving the files with some python
Good luck @alexloudon - if you find a solution - well worth posting it here to add to the body of knowledge.
Sean
