Solved Append Data to Excel Table

[CJ_London]

But would the connection be broken if theses excel files were sent out and the user did not have read access to the database?

No - it is a temporary connection same as your existing code.

However you have a solution, so I'm not pushing this on you, merely suggesting a simpler way of doing things.

Good luck with your project, but I'll drop out now