VBA connect to {dbname}-ondemand.sql.azuresynapse.net
Is it possible to connect to Synapse SQL (i.e. {dbname}-ondemand.sql.azuresynapse.net) from Excel/VBA?
I've tried using the ODBC connection string suggested in this article - https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/connect-overview#supported-drivers-and-connection-strings
But I am getting the following error:
Yeah, of course it's possible. Follow the instructions below and tou should be in business in no time at all.
https://docs.microsoft.com/en-us/azure/azure-sql/database/connect-excel