Skip to content

Instantly share code, notes, and snippets.

@juanobrach

juanobrach/Export Access DB to csv command line

Created May 26, 2019 23:00
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save juanobrach/8910829a16874197c6e1ddb9347e3e46 to your computer and use it in GitHub Desktop.
Save juanobrach/8910829a16874197c6e1ddb9347e3e46 to your computer and use it in GitHub Desktop.
Download ZIP
Export to CSV access database with PowerShell command line
Raw
access-export-to-csv-power-shell.ps1
$MsAccess = New-Object -ComObject Access.Application
$MsAccess.OpenCurrentDatabase('Database1.accdb')
$MsAccess.Run('export_query')
$MsAccess.CloseCurrentDatabase()
$MsAccess.Quit()
Raw
Export Access DB to csv command line
Run Power Shell script on comand line "./access-export-to-csv-power-shell.ps1"
Requirements
Database1 file or rename database name on script
Export query created as module on the DB
Public Sub export_query()
DoCmd.TransferText transferType:=acExportDelim, TableName:="Table1", FileName:="D:\Exported.csv", HasFieldNames:=True
DoCmd.Quit
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment