CODEWITHSUNDEEP
csvms-accessmdbtools
makewavesnotwar
makewavesnotwar

Reputation: 1015

mdb-export not creating CSV file

When I run mdb-export, the program dumps the comma delimited table to the terminal, but does not create a csv file as far as I can tell.

Is mdb-export creating a csv file somewhere or is this dump its intended function? If the latter is the case, how would one go about getting the output into a csv file?

Upvotes: 8

Views: 17869

Answers (4)

Eduard Florinescu
Eduard Florinescu

Reputation: 17521

You first need to install mdb-tools (Ubuntu, Debian):

sudo apt install mdbtools

Then to list the tables do this:

mdb-tables database.mbd

then with the desired table

mdb-export database.mdb table > table.csv

To export all the tables try this command:

mdb-tables -1 database.mdb | xargs -I{} bash -c 'mdb-export database.mdb "$1" >"$1".csv' -- {}

Upvotes: 22

Kunal
Kunal

Reputation: 21

mdb-export only dumps the contents of the file onto the screen. You need to give the '>' output redirector to save the contents onto a file. Ex: mdb-export DATABASE TABLE_NM > extract.csv

Upvotes: 2

Atihska
Atihska

Reputation: 5126

I have one of the db with table name containing spaces, so from this worked where quotes need to be added around table name: 

mdb-export Atlanta_All_Merchants..accdb 'table name with spaces' > output.csv

Upvotes: 2

makewavesnotwar
makewavesnotwar

Reputation: 1015

Alright, I ended up figuring it out. I was originally following the tutorial here and was running:

mdb-export database.mbd TABLE_NAME, but what I needed was

mdb-export database.mdb TABLE_NAME > output_file.csv

Upvotes: 16

Related Questions