Skip to content

Instantly share code, notes, and snippets.

@Hugoberry

Hugoberry/InsertSqlOleDb.m

Last active Apr 10, 2017
Embed
What would you like to do?
Exporting data out of Power Query into SQL Server via OleDb route
= 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
You can’t perform that action at this time.