cph / mdb

A library for reading Microsoft Access databases

Mdb

Wraps mdb-tools for reading Microsoft Access databases

Installation

Add this line to your application's Gemfile:

gem 'mdb'

And then execute:

$ bundle

Or install it yourself as:

$ gem install mdb

Usage

database = Mdb.open(PATH_TO_FILE)

# list tables in the database
database.tables 

# read the records in a table
database[:Movies]

Heroku

mdb-tools on heroku requires a custom buildpack.

Here is a sample project using this gem on heroku with configuration instructions:

https://github.com/jkotchoff/heroku_rails_microsoft_access_mdb_example

Contributing

1. Fork it
2. Create your feature branch (git checkout -b my-new-feature)
3. Commit your changes (git commit -am 'Add some feature')
4. Push to the branch (git push origin my-new-feature)
5. Create new Pull Request

mdb's Issues

[CVE|634238291] Vulnerability in bundler

Package: bundler

Affected versions: >= 1.14.0, < 2.1.0

Fixed version: 2.1.0

External link: CVE-2019-3881

Support MDB filenames starting with `--`

First off, thanks a lot for this gem:-)

We're using this to build importers for data migration from existing systems to our own dentist software. We therefore see many different filenames, even strange ones;-) One is especially strange as it follows the pattern --XXX.mdb. This one triggers an error when trying to import using this gem as the filename is parsed as options. The tools support using -- as a delimiter between options and the main argument.

Please use -- when calling the mdb- binaries to also support such filenames.

Thanks a lot!

Handle CSV not being part of Ruby standard library in 3.4.0

I got this warning after updating Ruby. Just an FYI.

warning: [...]/csv.rb was loaded from the standard library, but will no longer be part of the default gems since Ruby 3.4.0. Add csv to your Gemfile or gemspec. Also contact author of mdb-0.5.0 to add csv into its gemspec

Please link to this repo from rubygems.org

Congrats on the 0.4.0 release. I'm looking into upgrading. Had a mildly hard time finding this repo because there is no link from rubygems.org.