Where is the get data button in Excel?

Why can't I see get data in Excel?

I have this table.

I can see only the Headings in the grid when I click in the table. But When I run this function from Excel, I get nothing but errors and nothing else. Please, what am I doing wrong?
'Function that shows data on Grid in Excel. Public Sub ShowDataOnExcelGrid(). Dim myConnection As Connection. Set myConnection = New ADODB.Connection myConnection.Open ("Provider = Microsoft.ACE.OLEDB.12.0; Data Source = C:Users.Book1.xlsx; Persist Security Info = False;")
myConnection.CursorLocation = adUseClient Dim myCommand As New ADODB.CommandText = myCommandText myCommand.CommandType = adCmdText myCommand.ActiveConnection = myConnection Set myRecordset = myCommand.Execute myConnection.Close End Sub. Try with this code below. Option Explicit. Private Sub Command0Click(). Const connection As String = "Provider=Microsoft.0;Data Source=C:Usersd.sidd.2DesktopVinz-Schnellverfahren fr Elektro-AntriebeBook1.xlsx;Persist Security Info=False;"
Dim conn As New ADODB.Connection conn.Open connection Dim tdf As New ADODB.TableDef tdf.Connect = "ODBC;DSN=Excel 12.0;"
tdf.LockSeek = False tdf.RefreshLink = False conn.CommandTimeout = 0 tdf.CreateTable(Nothing)

Where is the get data button in Excel?

Why do we even have it on Excel?

Can anyone point me in the right direction as to how to get data from an excel file and then put that data into a new one and save it. Im using this example But I don't know why we need the getData button on there, it is so counter intuitive that I don't understand. Can anyone please tell me what exactly it does? getData is for retrieving data selected from a list. The button is for doing that and other common actions like sorting, filtering, etc.