Converting SQL for embedded use within VBA

$MyFile=get-content -Path "sql.txt" 
$outfile = "sqlNew.txt"
Remove-Item $outfile -ErrorAction SilentlyContinue
$str=$null;
$firstLine=$true;
for ($i=0; $i-lt $MyFile.Count; $i++)
{
if ($str.length -gt 80)
{
    if ($firstLine)
    {
        $str = '"' + $str + '" _'
        $firstLine=$false;
    }
    else
    {
        $str = '& "' + $str + '" _'
    }
    Add-Content $outfile "$($str)`n"
    $str=$null;
}
$nextLine = $MyFile[$i]
$nextLine = $nextLine.Replace("`t"," ");
$nextLine = $nextLine.Replace("  "," ");$nextLine = $nextLine.Replace("  "," ");$nextLine = $nextLine.Replace("  "," ");
$idx = $nextLine.indexof("--");
if ($idx -ge 0)
{
    $nextLine = $nextLine.Substring(0,$idx)
}
 
$str = $str + ' ' + $nextLine;
 
}
 
if ($firstLine)
{
    $str = '"' + $str + ' "'
}
else
{
    $str = '& "' + $str + ' "'
}
Add-Content $outfile "$($str)`n"
$str = $null;

$MyFile=get-content -Path "sql.txt" $outfile = "sqlNew.txt" Remove-Item $outfile -ErrorAction SilentlyContinue $str=$null; $firstLine=$true; for ($i=0; $i-lt $MyFile.Count; $i++) { if ($str.length -gt 80) { if ($firstLine) { $str = '"' + $str + '" _' $firstLine=$false; } else { $str = '& "' + $str + '" _' } Add-Content $outfile "$($str)`n" $str=$null; } $nextLine = $MyFile[$i] $nextLine = $nextLine.Replace("`t"," "); $nextLine = $nextLine.Replace(" "," ");$nextLine = $nextLine.Replace(" "," ");$nextLine = $nextLine.Replace(" "," "); $idx = $nextLine.indexof("--"); if ($idx -ge 0) { $nextLine = $nextLine.Substring(0,$idx) } $str = $str + ' ' + $nextLine; } if ($firstLine) { $str = '"' + $str + ' "' } else { $str = '& "' + $str + ' "' } Add-Content $outfile "$($str)`n" $str = $null;