Hi All,
I have been trying to use ADODB to open a CSV file (only coma separation, no double quotes around each field).
I use the following connection string
$connStr = 'Provider=Microsoft.Jet.OLEDB.4.0; Data Source=' & $csvPath & _
';Extended Properties="Text;HDR=No;FMT=Delimited(,);IMEX=1";'
$objConn.Open($connStr)
$objRS.Open("Select * From " & $csvFile, $objConn, $AD_OPEN_STATIC, $AD_LOCK_OPTIMISTIC, $AD_CMD_TEXT)
$hearderRow = $objRS.GetRows(1)
However the header