csv-to-access-importer

Command-line tool for importing CSV data to MS Access databases (.mdb, .accdb) from Linux and macOS. Works on Windows as well, but more sophisticated options exist there.

This project heavily relies on Jackcess.

Usage

Usage: import [-chtV] [-o=<dependencyOrder>] <targetFile> <inputDir>
Imports a set of CSV files to the target MDB or ACCDB database.
      <targetFile>      Path to the target MDB or ACCDB database.
      <inputDir>        Path to the directory that contains the CSV files.
  -c, --[no-]create     Automatically create missing tables (default: true).
  -h, --help            Show this help message and exit.
  -o, --order=<dependencyOrder>
                        Comma separated list of table names to process in this
                          order. All other tables will be processed afterwards,
                          in alphabetical order.
  -t, --[no-]truncate   Truncate tables before the import (default: false).
  -V, --version         Print version information and exit.

For example:

java -jar csv-to-access-importer-1.0.0-all.jar --no-create --truncate /data/out.accdb /data/input-folder/

License

See LICENSE.md for details.