Excel 2016-Use MS Query Question

[ctsuhako]

Hello:

I would like to create and save a simple MS Query from Excel 2016 to an ODBC connected database. However, the table layout that I need to access changes constantly (the table is used to run a query once to be pulled into Excel and is overwritten each time it is used). Is there a simple way to do this? Thank you!

 

[chicagocomputerclasses]

It's not 100% clear to me what the issue is.
From what I can tell your field names in your table change.
You don't need to refer to particular fields in your ODBC connection to pull the data to Excel, you can simply refer to the table you need.
It should build a connection string with [Data] referring to all the data in that table.

dbo_Schema{[Name="tablename",Kind="Table"]}[Data]

So to sum it up, just build your ODBC connection, just make sure you don't remove or pick any individual fields(columns) from the table.