Can I use Power Query to post data to a SQL Server DB?

[piannetta]

Hi,

I've searched online and in Help and can't seem to find anything on this topic, but I'm keen to know if it's possible to use Power Query / Get & Transform in Excel to write data from my Excel spreadsheet to a table in an SQL DB?

I currently use Excel to manually track a bunch of data and the reporting people would like to query it as part of reports they are building in PowerBI. I figured if I could somehow automatically upload that data to a SQL DB table, that would enable them to do this.

Cheers,
Pete

 

[VBA Geek]

https://blog.crossjoin.co.uk/2018/10/07/power-query-write-data/