Skip to content

Instantly share code, notes, and snippets.

@Hugoberry

Hugoberry/InsertSqlAdoDb.m

Last active April 10, 2017 09:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Hugoberry/2dbe7da8f04205dbb868cb28d46a68d1 to your computer and use it in GitHub Desktop.
Save Hugoberry/2dbe7da8f04205dbb868cb28d46a68d1 to your computer and use it in GitHub Desktop.
Download ZIP
Exporting data out of Power Query via AdoDb route
Raw
InsertSqlAdoDb.m
= Value.NativeQuery(
Sql.Database(".", "QueryPower"),
"INSERT INTO [dbo].[Demo] VALUES(@key,@value)",
[key=10,value="A"])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment