Hi All, I have a excel workbook that reads a SQL script, queries a SQL DB then returns the data directly into a worksheet. The worksheet that the data returns to has a data connection type of OLE DB Query and the VBA that make this happens is as follows: Sheets("DataSheet").Select Range("A1").Select With Selection.QueryTable .Connection = _ "OLEDB;Provider=SQLOLEDB;Server= \;App=Report_Name.xls;Database= ;Trusted_Connection=yes;" .Sql = theQueryText .Refresh BackgroundQuery:=False End With The problem I have is that now our company has moved to an Azure DB and requires a Microsoft login which I have but I can't seem to work out how to adapt my workbook for azure. Anyone know how I can do this? Is it even possible? Thanks, Ben

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

OLE DB Query on Azure

Thread starter BensTooCool
Start date Aug 6, 2021

BensTooCool

New Member

Aug 6, 2021

Hi All,

I have a excel workbook that reads a SQL script, queries a SQL DB then returns the data directly into a worksheet. The worksheet that the data returns to has a data connection type of OLE DB Query and the VBA that make this happens is as follows:

Sheets("DataSheet").Select
Range("A1").Select

With Selection.QueryTable
.Connection = _
"OLEDB;Provider=SQLOLEDB;Server=<SERVER NAME>\;App=Report_Name.xls;Database=<DATA BASE>;Trusted_Connection=yes;"
.Sql = theQueryText
.Refresh BackgroundQuery:=False
End With

The problem I have is that now our company has moved to an Azure DB and requires a Microsoft login which I have but I can't seem to work out how to adapt my workbook for azure.

Anyone know how I can do this? Is it even possible?

Thanks,

Ben