$Path = "****"
$server = '****'
$database = 'Emails'
$table = 'Exchange_Export'
$FileArray = Get-ChildItem $Path
$i = 0

Do{
     $File = $fileArray[$i]
    $Files = $path+"\"+$File
    $query = "BULK INSERT " + $table+" FROM '"+$Files+"' WITH (KEEPIDENTITY, FIELDTERMINATOR = ',', ROWTERMINATOR = '\n');"
    Invoke-Sqlcmd -Query $query -ServerInstance $server -Database $database
    $i
    $i++
 }While ($i -le $FileArray.count)