All Projects → maxogden → Node Mdb

maxogden / Node Mdb

use mdbtools from node to convert MS Access databases to CSV

Programming Languages

javascript
184084 projects - #8 most used programming language

mdb

npm install mdb

what

use the mdbtools CLI tool (written in C) from node to convert MS Access databases to CSV

these aren't native bindings, they just talk to stdin/stdout/stderr of mdbtools (specifically mdb-tables and mdb-export)

requirements

install https://github.com/brianb/mdbtools. as of this writing I could only get it to compile on Ubuntu and not OS X

also as of this writing mdbtools supports .mdb and .accdb files up through Access 2010

usage

var fruit = mdb('fruit.mdb')

fruit.tables(function(err, tables) {
  tables.forEach(function(table) {
    fruit.toCSV(table, function(err, csv) {
      console.log(err, table, csv.split('\n').length - 1 + " lines")
    })
  })
})

MIT LICENSE

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].