Export Access data to csv file
We already have all the functionality we need to achieve this.
$db = Open-AccessDatabase -name test03.mdb -path c:\test
Get-AccessData -sql "select * from test1" -connection $db | Export-Csv -Path c:\test\test1.csv –NoTypeInformation
Open the csv file in Excel and the data is available. If you open the csv file in notepad be aware that the fields are padded and you need to scroll to the right to see all the data.
We could add the export functionality into our Get-AccessData function but if we stick with the PowerShell composability concepts we want to keep the functions small and focussed. If you want to change the function – feel free – just add a switch for csv output and a parameter for the csv path. Then use another if statement to control writing to the csv.