Queries & Connection

[TL30N]

Good morning,

I used to enter my SQL by going into Excel --> Data --> Connections and then add new connection.

The tab now has a label called "Queries & Connections" and I can't see where I can add new connections, I've clicked on the new label, but there's nowhere I can see to add a new connection.

My PC downloaded a new version of Office this morning, I'm using Excel 2016, has anyone else experienced this?

Thanks,

Taylor

 

[ranman256]

you can try it with code:
usage:
CONNECTDB() 'when the workbook opens

save data:
RunActionQry "Insert into table (clientID,Phone) values (123, '534-555-1234')", true

public goConn as ADODB.Connection

'-----------------
sub ConnectDB()
'-----------------
gDB = "\\server\folder\myDb.accdb"

sConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & gDB
OLEDB:EngineType=4"
Set goConn = New ADODB.Connection
goConn.Open sConnect
end sub

'-----------------
Public Function RunActionQry(pvQry, Optional ByVal pbIsSql As Boolean)
'-----------------
On Error GoTo errRun

  ' Assign to ADO Command object
Set goCmd = New ADODB.Command
With goCmd
  .ActiveConnection = goConn
  .CommandText = pvQry
  
  If pbIsSql Then
    .CommandType = adCmdText
  Else
    .CommandType = adCmdStoredProc
  End If
  
  .Execute
End With
Exit Function


errRun:
RunActionQry = Err
End Function

 

[Paul Ked]

Look at this

https://www.mrexcel.com/forum/excel...nly-want-create-connection-not-load-data.html

Answered yesterday!