Demos write-dbadatatable

DemoWrite-DbaDataTable.ps1

import-module dbatools,ImportExcel;
$MyQuery = @"
select * from sys.databases where [name] = @DBName
"@;

$Params = @{"DBName" = "model"};
Invoke-DbaSqlQuery -SqlInstance YOURSERVER -Query $MyQuery -SqlParameters $Params | export-excel -Path e:\tmp\myfile.xlsx;

$MyData = Import-Excel -path e:\tmp\myfile.xlsx;
$MyData|ConvertTo-DbaDataTable|Write-DbaDataTable -SqlInstance YOURSERVER -database Demo -Table MyTable -Schema dbo -AutoCreateTable;
Remove-Item e:\tmp\myfile.xlsx;

Invoke-DbaSqlQuery -SqlInstance YOURSERVER -Query "select * from demo.dbo.mytable";

remove-module dbatools,ImportExcel;