Apologies, first time using this. I believe I need the connection to link VBA to the server used for SQL.
Here's the code I am using currently which generates a userform/textbox where I manually copy and paste the code into SQL and run the query.
Sub UploadSQL()
Application.ScreenUpdating...