Bonjour,
Je cherche le moyen de connecter une bdd sql directement dans power query.
J'ai la connexion en VBA :
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim cmd As New ADODB.Command
Dim sSQL As String
Dim qt As QueryTable
Set conn = New ADODB.Connection
conn.ConnectionString = "Provider=sqloledb;" & _
"Data Source=xxxx;" & _
"Initial Catalog=xxxx;" & _
"User Id=xxxx;" & _
"Password=xxxx"
conn.Open