---

try 
{
 $cmd = $Connection.CreateCommand()
 $cmd.CommandText = "DROP TABLE Temp"
 $cmd.ExecuteNonQuery() | Out-Null
}
catch {}

$cmd = $Connection.CreateCommand()
$cmd.CommandText = @"
CREATE TABLE Temp (
 PurchasingDocument TEXT(50),
 Item TEXT(10),
 NameOfVendor TEXT(50),
 DateSendToSupplier DATETIME,
 GoodsSupplierNumber TEXT (100),
 GoodsSupplierName TEXT(100),
 CompleteName TEXT(255)
)
"@

$cmd.ExecuteNonQuery()

foreach ($__row in $FilterTable) {
 $cmd = $Connection.CreateCommand()
 $cmd.CommandText = @"
 INSERT INTO Temp 
 (PurchasingDocument, Item, NameOfVendor, DateSendToSupplier, GoodsSupplierNumber, GoodsSupplierName, CompleteName) 
 VALUES (?, ?, ?, ?, ?, ?)
"@
 
  $null = $cmd.Parameters.Add("@p1",[System.Data.OleDb.OleDbType]::VarWChar, 50)
  $cmd.Parameters[0].Value = [string]$__row.'Purchasing Document'
 
  $null = $cmd.Parameters.Add("@p2",[System.Data.OleDb.OleDbType]::VarWChar, 10)
  $cmd.Parameters[1].Value = [string]$__row.Item
 
  $null = $cmd.Parameters.Add("@p3",[System.Data.OleDb.OleDbType]::VarWChar, 255)
  $cmd.Parameters[2].Value = [string]$__row.'Name Of Vendor'
  
  $null = $cmd.Parameters.Add("@p4",[System.Data.OleDb.OleDbType]::Date)
  $cmd.Parameters[3].Value = [string]$__row.'Date sent to Supplier.'
  
  $null = $cmd.Parameters.Add("@p5",[System.Data.OleDb.OleDbType]::VarWChar, 50)
  $cmd.Parameters[4].Value = [string]$__row.'Goods supplier numb.'
  
  $null = $cmd.Parameters.Add("@p6",[System.Data.OleDb.OleDbType]::VarWChar, 50)
  $cmd.Parameters[5].Value = [string]$__row.'Goods supplier name'
  
  $null = $cmd.Parameters.Add("@p7",[System.Data.OleDb.OleDbType]::VarWChar, 50)
  $cmd.Parameters[6].Value = [string]$__row.'Complete name'
 
 $cmd.ExecuteNonQuery() | Out-Null
}