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 -
CodePudding user response:
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