Insert data to list from Excel file

$SiteURL =  "http://abc.com";

$ListName = "MarketingProducts";

$ExcelFilePath =  "C:\MP.xls";

$ExcelSheetName = "Product"

$OleDbConn = New-Object “System.Data.OleDb.OleDbConnection”

$OleDbCmd = New-Object “System.Data.OleDb.OleDbCommand”

$OleDbAdapter = New-Object “System.Data.OleDb.OleDbDataAdapter”

$DataTable = New-Object “System.Data.DataTable”

$OleDbConn.ConnectionString = “Provider=Microsoft.ACE.OLEDB.12.0;Data Source=$ExcelFilePath;Extended Properties=”"Excel 12.0 Xml;HDR=YES”";”

$OleDbConn.Open()

$OleDbCmd.Connection = $OleDbConn

$OleDbCmd.commandtext = “Select * from [$ExcelSheetName$]”

$OleDbAdapter.SelectCommand = $OleDbCmd

$RowsReturned = $OleDbAdapter.Fill($DataTable)

$intRow = 1

ForEach ($DataRec in $DataTable) {

#Write-host “Address=$($DataRec.Address)”

#Write-host “Site Name=$($DataRec.{Site})”

$spAssignment = Start-SPAssignment

    $mylist = (Get-SPWeb -identity $SiteURL -AssignmentCollection $spAssignment).Lists[$ListName]

    $newItem = $mylist.Items.Add()

    $newItem["Title"] = $intRow

    $newItem["ProductID"] = $($DataRec.{ProductID})

    $newItem["ProductName"] = $($DataRec.{ProductName})

    $newItem["ProductDescription"] = $($DataRec.{ProductDescription})

    $newItem["ProductPrice"] = $($DataRec.{ProductPrice})

    $newItem["ProductImageURL"] = $($DataRec.{ProductImageURL})

    $newItem["DetailsPageURL"] = $($DataRec.{DetailsPageURL})

    $newItem["ProductPriceHTML"] = $($DataRec.{ProductPriceHTML})

$newItem["Location"] = 'POINT(' + $($DataRec.{Long}) + ' ' + $($DataRec.{Lat}) + ')'

$intRow++

    $newItem.Update()

    Stop-SPAssignment $spAssignment

}

$OleDbConn.Close()