A long time ago I wrote a module for working with Access databases. I also added a couple of independent functions. The Access module and functions are now available on github.
People have asked about getting the module and while its had a number of temporary homes its permanent home is now the github repsoitory – https://github.com/RichardSiddaway/AccessFunctions
The module comprises the following functions:
Add-AccessRecord
Close-AccessDatabase
Get-AccessData
Get-AccessStoredProcedure
Get-AccessTableDefinition
Invoke-AccessStoredProcedure
New-AccessColumn
New-AccessDatabase
New-AccessIndex
New-AccessStoredProcedure
New-AccessTable
Open-AccessDatabase
Remove-AccessColumn
Remove-AccessData
Remove-AccessIndex
Remove-AccessStoredProcedure
Remove-AccessTable
Reset-Autonum
Set-AccessData
Test-AccessConnection
The independent functions are:
bulkload.ps1
new-table.ps1
All of the functions are supplied as is without warranty or guarantee.