Recent changes to feature-requests

Export to SQLite schema

2012-10-19T11:51:35Z

It would be very interesting to see mdbtools exports to SQLite schema directly. This page explains how to do this using a perl script, but it certainly is a cumbersome job.

http://cltb.ojuba.org/en/articles/mdb2sqlite.html

This option would be very useful for convert MDB files to this database increasingly used.

Support for cleanly import in MySQL

2009-11-01T18:28:25Z

Same bases of MS have tables and columns named as "dirty" - non-latin characters, large 15 characters, have spaces and other incorrect symbols.
Will be ideally if mdbtools will have an options for convert incorrect names of tables and colums on the fly.
Example: Table name "Name of table bad #Ы1" --> "nameoftablenum1" (name large<15, no spaces, no-command symbols, no non-latin symbols).
But don't forget - this may be need check no-repeate names of tables and columns in the one base!
Help me!

Write mdb files

2006-03-23T12:42:22Z

I know this is a recurrent issue, but is anyone
actually working in this functionality?. OO.org uses
mdbtools and I guess this will be a great feature, very
useful in migration tasks.

Support for Access 4.3

2005-12-07T22:53:32Z

Yes, believe it or not I have a database from MS Access
4.3 (the last 16-bit version of Office, circa
1993-1994). I can provide the database (which has
considerable sentimental value) if desired.

Support for password protected databases

2005-01-08T08:23:36Z

As in title

mdb-sql as a coprocess

2004-12-01T06:55:17Z

I'm making heavy use of mdb-sql because I have to work
with
Access files produced by other people. But at the end
of the
day, I have a limited number of reports to generate from
them. To generate these reports, I'm using TCC as my
scripting language. As a result, I write the programs
generating my reports in C. One of the things I really
missed
was the possibility of running mdb-sql as a coprocess and
simulating user interaction from the C programs, like

fprintf(tosqlpipe,"select * from table\ngo\n");

and then read the output from mdb-sql via fgets(...). The
programs would consistently halt at the fgets, because no
input was available. Attached is a patch, which
includes the
necessary fflush() 's in mdb-sql, to make this interaction
possible.

The patch is generated on version 0.5, because 0.6pre1
doesn't work on the mdb files I work with.

ORDER BY clause

2004-08-27T17:09:52Z

Sometimes i need to use ORDER BY ASC/DESC clause in my
sql statements, this is possible to implement in mdbtools?

mdb-export: support specifying date format

2003-01-27T16:50:32Z

I find useful to specify the date format to the
mdb-export utility, or at least an option to specify
ISO date style (YYYY-MM-DD).

New release - ODBC driver

2003-01-03T18:40:00Z

Nice to see Brian is back, hope he'll get a new release
soon.
In this new release it would be great to see a
prepackaged ODBC driver that works well with PHP and
unixODBC.
Thanks in advance.