← Back to Access Data

Odbc.InferOptions

This function determines the SQL capabilities with the specified connection string using ODBC. The connection string can consist of either text or a collection of key-value pairs. The values of the pr...

Syntax

Odbc.InferOptions(connectionString as any) as record.

About

This function determines the SQL capabilities with the specified connection string using ODBC. The connection string can consist of either text or a collection of key-value pairs. The values of the properties can be either text or numeric.

Explanation

Retrieve the estimated SQL capabilities for a connection string using Power Query M function MOdbc.InferOptions("dsn=your_dsn"). The output will be displayed as a Power Query M record.