I am having multiple columns in Access DB. I want 2 columns from there exported to CSV. I can see them in console screen but unable to output them as CSV. Code i am using is :
$adOpenStatic = 3 $adLockOptimistic = 3 $conn=New-Object -com "ADODB.Connection" $rs = New-Object -com "ADODB.Recordset" $conn.Open('Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\risha\Desktop\PowerShell DataBase\dba.mdb;Persist Security Info=True;') $rs.Open("SELECT * FROM inclearing",$conn,$adOpenStatic,$adLockOptimistic) $rs.MoveFirst(); do { $rs.Fields.Item("Column1").value $rs.Fields.Item("Column9").value $rs.MoveNext(); }until($rs.EOF -eq $true) $conn.Close $rs.Close
I tried this also :
$rs.Open("SELECT Column1,Column9 FROM inclearing",$conn,$adOpenStatic,$adLockOptimistic) | Export-Csv -Path C:\Users\risha\Desktop\test1.csv -Encoding "UTF8" -NoT