Insert data through Excel to an existing SQL table using power query
I am working on a little PowerQuery project.
Insert data through Excel to an existing SQL table using power query
I am working on a little PowerQuery project.
Insert data through Excel to an existing SQL table using power query
I am working on a little PowerQuery project.
Why does my excel powerquery result in a Token ‘,’ expected error?
I’m trying to pull data from SQL and use a dynamic reference within the excel workbook. The query works fine if I hardcode the Yr reference in the WHERE statement, so I think it has something to do with that. I’m pretty good and SQL and know this query works there, but was trying to write it to pull directly into excel instead of copying it over.
Excel PowerQuery – referencing long query
This is hypothetical information, but hope it’s enough to understand my question.