Forum Discussion
Using Paramters to define ODBC connection
Hi, Wondering if there's a way to use a parameter to define the ODBC Data source. I want to connect via CData's ODBC driver for Xero. This provides access to multiple tables via SQL statements. I...
That changes the error to:
Expression.Error: There is an unknown identifier. Did you use the [field] shorthand for a _[field] outside of an 'each' expression?
Sorry!
I think this will work:
= Odbc.Query("dsn=" & Connection & "", Select * from TrialBalance where date=[PeriodEnding]")