AddPowerQuery Adds a connection using power query. This requires a connection string using the Microsoft.Mashup.OleDb.1 provider and a M-Formula to describe the data source. AddDatabase Adds a ...
pivot-to-sql automatically converts Excel pivot table reports into optimized SQL queries for direct database execution. See the source code for full details and usage instructions.