M365 Excel Python - how to connect to Azure SQL DB?
Hi, we are evaluating the python add in for Office 365 Excel. The aim is to be able to create an Excel sheet of values from various python and excel functions and calculations. Then to upload the sheet each day to save to an SQL DB. The idea is to be able to pull down and upload data from the sheet for any specific date from the SQL DB into a new Excel file as and when needed by the user. Can anyone help with the actual python code that can be used inside Excel to communicate with an Azure SQL DB? I found some suggestions on stack overflow, but it looks more related to python programming than Excel. I have set up an SQL authentication login for our user. Management Studio connects ok, its just the code on the Python Excel side that i need to get. Can anyone provide the connection code? Or link to some documentation? Thanks, Nick.