---

$cmd = $Connection.CreateCommand()
$cmd.CommandText = @" 
INSERT INTO [$Item] 
( 
	Column0, 
	Column1, 
	Column2, 
	Column3, 
	GoodsSupplierNumber, 
	GoodsSupplierName, 
	CompleteName, 
	StatusLetter, 
	ResponseLetter 
)
SELECT 
	?, 
	[PurchasingDocument], 
	[Item], 
	[Name of Vendor], 
	[GoodsSupplierNumber], 
	[GoodsSupplierName], 
	[CompleteName], 
	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()