---

$cmd = $Connection.CreateCommand()
$cmd.CommandText = @" INSERT INTO [$Item] ( Column0, Column1, Column2, Column3, [Goods supplier number], [Goods supplier name], [Complete Name], StatusLetter, ResponseLetter )
SELECT ?, [PurchasingDocument], [Item], [Name of Vendor], [Goods supplier number], [Goods supplier name], [Complete Name], 0, False
FROM [Temp]
WHERE NOT EXISTS ( SELECT 1 FROM [$Item]
WHERE [$Item].[Column1] = [Temp].[PurchasingDocument]
AND [$Item].[Column2] = [Temp].[Item]
) "@
$null = $cmd.Parameters.Add( "@p1", [System.Data.OleDb.OleDbType]::VarWChar, 10 )
$cmd.Parameters[0].Value = $Item
$cmd.ExecuteNonQuery() | Out-Null
$cmd.Dispose()