Query vs Connection

[BMil8]

Hello. Not very knowledgeable in this area. Can somebody tell me the difference between these queries? Why does one say "Connection Only" and the others show the number of rows?

 

[Micron]

What version of Access is this? I have not seen that in the navigation pane & have to think that it means it's a pass-through query. Or did you mean to post in the Excel forum instead?

 

[BMil8]

Sorry, this is in an Excel file but it's pointing to a table in Access. Better to post in Excel forum?

 

[Domenic]

For an explanation of "Connection only" see the following . . .

What is "connection only" mode do in Power Query?

I believe the options I have for pulling data sources is 1) connection only, 2) load to data model or 3) load to spreadsheet. 2) and 3) seem obivous but when I load connection only, are my scripts...

superuser.com

For the difference between Queries and Connections see the following . . .

Connection vs Query in Excel data model

What is the difference between a 'connection' and a 'query' as Excel defines it in their data model? For example, if I load a csv file from local, it stores that as a query (it shows a 'select *' a...

stackoverflow.com

 

[Micron]

It's been a long time since I created any queries in Excel (I think the tool was called MSQuery). Have been wondering for a while what Power BI (?) is, but it seems it's the old MSQuery tool reborn? It's really an Excel question because that's the app you're using IMO, but it doesn't matter since you've explained it.