Excel VBA：OLEDB Connection.CommandText错误

Hello: I've had success with a long SQL (Oracle) as the Command Text in an OLEDB Data Connection that I entered manually. I then had success entering the SQL via VBA (because I need it to update based on a changing Item List), and only running the first part of the union query as a test.Hello: I've had success with a long SQL (Oracle