Jackcess is supposed to support the 2007 format. The FAQ is quite clear
on this. If you wish to try the Jackcess way of reading an accdb file
then you could try to do this with Pentaho Data Integration (community
edition). Its uses Jackcess to read accdb / mdb files. The current
version of Jackcess no longer supports A97 format.

To the best of my knowledge there is no 'standard' front end to
Jackcess. It is a java library, not an application in and of itself. You
could probably create something without too much trouble using Eclipse
as a base. The nearest you will find I think is to build a type of
'ripper' data process in Pentaho. Iterate the tables, queries,
relationships, etc... for what you want, then have it push the results
to csv format files. Once the 'ripper' is built you can simply execute
it from the command line of that is what you want. Someone may have
already created such a 'ripper' since there are many access database
files floating around inside companies....... You would have to ask in
the Pentaho forums for this.
--
Cheers

The Frog

If you have Excel (or any other ODBC-compliant application), you may be able
to pull the data from Access, as opposed to pushing it to a text file.

"MartinΤrautmann" wrote in message
news:slrnj85icr.9p4.t-usenet (AT) ID-685 (DOT) user.individual.de...

Hi all,

is there something like the mdbtools for Access 2007 format?

I got a large .accdb database which should be converted to a text format
such as .csv.

Preferably a shell solution should do the job - or a Mac frontend for
jackcess.

Thanks,
Martin

"Martin ?rautmann" <t-usenet (AT) gmx (DOT) net> wrote


OpenOffice.org?

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)

Martin =?UTF-8?Q?=CE=A4rautmann?= <t-usenet (AT) gmx (DOT) net> wrote in
news:slrnj875s3.9p4.t-usenet (AT) ID-685 (DOT) user.individual.de:

That shouldn't be an issue for Excel 2007/2010, which increased the
number of rows.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

"MartinΤrautmann" wrote in message
news:slrnj85icr.9p4.t-usenet (AT) ID-685 (DOT) user.individual.de...


Just keep in mind, for at least the last about dozen years you could read
and extract and pull data out of an access mdb file without installing
anything on recent editions of windows.




Hum, ok, it seems like you looking for a non windows solution here.

You can certainly download and install the ACE data engine. This will allow
odbc software to open and read an accdb file.
You can find this install here:
http://www.microsoft.com/download/en...ng=en&id=13255

However the above connected the components obviously have to be installed on
a windows machine.

So just to be clear you do not need the free Access runtime or a retail
edition of Access to read and open accdb files. So just like mdb files, you
don't need Access to read and extract data out of a accDB file.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com

Hi Martin,

As I mentioned in my previous post you can use Pentaho Data Integration
to push and pull data from accde / mdb files without the need for Access
to be installed. The entire application is written in Java. Producing
CSV files is exceptionally easy. Pushing the data to another database is
also quite easy with this tool. If you wish to run it as a 'service' or
a cron job this is also possible. The same 'solution' you develop in
Pentaho in deployable across any platform that support a full java
implementation.
--
Cheers

The Frog

Martin =?UTF-8?Q?=CE=A4rautmann?= <t-usenet (AT) gmx (DOT) net> wrote in
news:slrnj8hb2a.2j08.t-usenet (AT) ID-685 (DOT) user.individual.de:

If you're not using Windows, you're a complete idiot for using
Jet/ACE. It's very, very closely tied to the file system and I don't
believe it can be trusted on any other file system.

And, of course, there's never been any effort on MS's part (and
never will be) to port it to other platforms.

It's just silly to choose a database engine that is Windows-only
when you're not using Windows at all. Every time I see people doing
it, it makes me wonder why they think it's a good idea.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

I would agree with you for the development side of things David, but not
for all cases. In my experience there are a large number of databases
that hold 'essential' data that are stored in MDB files. This is usually
a legacy of older work methodologies or perhaps even the work practices
of third party groups with whom you need to interact. In my cases, as
with the OP's, it was not a choice I was able to make.

The ability to read data from an MDB file is a very useful skill / tool
to have for any OS. Often times you need to work with Linux based OS
systems, particularly servers, that require the ability to at least read
data from clients without having to build entire new pieces of
infrastructure to support this. This is the scenario that led me to
first working with Access. It is also the scenario that led me to work
with Pentaho.

I would surely not develop in a Linux system with Access, but reading
and extracting data is a common task that requires only a subset of the
capabilities of JET / ACE, and is quite stably achieved with third party
tools on non Windows OS machines. Anyone trying to develop an Access app
on a non Windows machine is asking for trouble, but bear in mind that
simply reading the data is another scenario entirely, and is a common
requirement. Working in Windows with Access is certainly preferable, but
not essential in all cases.
--
Cheers

The Frog