accessdb - Linux


accessdb is a versatile command-line tool designed to manage and interact with Microsoft Access databases in Linux environments. It empowers users to perform various operations on Access databases, including data extraction, manipulation, and analysis.




  • -h, –help: Print usage information.
  • -f, –file: Specify the path to the Access database file.
  • -s, –sheet: Select a specific sheet within the database.
  • -q, –query: Execute a SQL query on the database.
  • -c, –command: Execute a built-in accessdb command.
  • -o, –output: Specify the output format (csv, json, xml, md).
  • -v, –verbose: Enable verbose output.


Extract data from a table

accessdb -f database.accdb -sheet employees -command select *

Execute a SQL query

accessdb -f orders.accdb -query "SELECT * FROM Orders WHERE Total > 100"

Convert a table to CSV

accessdb -f invoices.accdb -sheet invoices -command export -o csv

Common Issues

  • Invalid database format: Ensure the provided database file is in the correct Access database format (.accdb).
  • Missing permissions: Verify that you have read/write permissions to the database file.
  • Incorrect syntax: Double-check the syntax of your command and ensure all required arguments are provided.


accessdb can be integrated with other commands and tools for advanced tasks:

  • Bash: Use accessdb to dynamically extract data for use in scripts.
  • Pandas: Import data from accessdb into a Pandas DataFrame.
  • Query tools: Combine accessdb with SQL query tools like MySQL Workbench for more complex data analysis.

Related Commands