Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@Hugoberry

Hugoberry/InsertSqlOleDb.m

Last active April 10, 2017 09:52
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/d30e78d004e1ab3fcbe1115ed54a5dc2 to your computer and use it in GitHub Desktop.
Save Hugoberry/d30e78d004e1ab3fcbe1115ed54a5dc2 to your computer and use it in GitHub Desktop.
Download ZIP
Exporting data out of Power Query into SQL Server via OleDb route
Raw
InsertSqlOleDb.m
= OleDb.DataSource(
"provider=SQLOLEDB.1;data source=.;database=QueryPower",
[Query=Text.Format("INSERT INTO [dbo].[Demo] VALUES(#{0},'#{1}')",{1,"A"})])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment