Point this query to your database table and return all columns and schema meta data using Power Query in Excel
me@jaykilleen.com wrote this about 3 years ago and it was last updated about 3 years ago.
let
Source = Odbc.Query("dsn=insert-windows-odbc-data-source-connection-name-here",
"
SELECT
*
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_SCHEMA = 'insert-table-name-here'
"
)
in
Source