Microsoft Access Database

Tools · 11

• list List all active databases available in the server.
• create Create a new database file (for Microsoft Access, copies the empty.mdb template).
• connect Connect to an existing database file, or creates an in-memory database if the file is not specified.
• disconnect Close a database connection. For in-memory databases, this will clear all its data.
• query Execute a SQL query to retrieve data from a database.
• update Execute a SQL query to insert/update/delete data in a database.
• import_csv Imports data from a CSV file into a database table.
• export_csv Exports data from a database table to a CSV file.
• import_excel Imports data from an Excel file into a database table.
• read_notes Reads notes from the specified file, or discovers notes in the specified directory.
• write_notes Writes notes to the specified file, or linked to the specified database.