access2csv

Simple program to extract data from Access databases into CSV files.

Features

• view the schema of the database
• export all tables to csv files named after the table
• export one table

Examples

Dumping a schema:

$ ./access2csv --input=myfile.accdb --schema	
CREATE TABLE Test(
	Id INT,
	Name TEXT,
)
CREATE TABLE Test2(
	Id INT,
	Name TEXT
)

To Save the schema in a file:

$ ./access2csv --input=myfile.accdb --schema > schema_file_name

Exporting all tables:

$ ./access2csv --input=myfile.accdb --output=<output_location>
Exporting 'Test' to /home/ryepup/Test.csv
2 rows exported
Exporting 'Test2' to /home/ryepup/Test2.csv
100000 rows exported

Command Options:

--input // reuqired. input file location
--output // required. output file location
--write-null // optional. Default value for NULL. i.e NULL | "" | false | <anything> 
--quote-all // optional. false | true
--schema // optional. Dump the DB schema
--with-header // optional. Write CSV with header

Export one table:

$ ./access2csv myfile.accdb Test
1,"foo"
2,"bar"

Installation

Binaries are available at https://github.com/AccelerationNet/access2csv/releases, download a jar file from there then use it as shown above.

Compile from source

$ git clone https://github.com/AccelerationNet/access2csv.git
$ cd access2csv
$ mvn clean install

To skip test during build:

$ mvn clean install -DskipTests

Now you should have a access2csv.jar in the target directory, ready to go.

Note December 2017. Things have changed a little. If nothing else works then, (after compiling with mvn clean install) try running something like this (example of Windows batch file) in the root of the repository (replace the path\to\file):

 ".\target\appassembler\bin\access2csv.bat" --input ".\path\to\file" --output . --write-null NULL --quote-all false --schema --with-header 

Dependencies

• Jackess - a pure Java library for reading from and writing to MS Access databases
• opencsv - CSV library

Contributing

Use https://github.com/AccelerationNet/access2csv to open issues or pull requests.