Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: .accdb to csv /wo Access
368 views
Skip to first unread message
Message has been deleted
The Frog
Sep 28, 2011, 5:10:12 AM9/28/11
to
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
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
Douglas J Steele
Sep 28, 2011, 5:34:27 PM9/28/11
to
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....@ID-685.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
to pull the data from Access, as opposed to pushing it to a text file.
"MartinΤrautmann" wrote in message
news:slrnj85icr....@ID-685.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
Message has been deleted
Clif McIrvin
Sep 28, 2011, 6:06:06 PM9/28/11
to
"Martin ?rautmann" <t-us...@gmx.net> wrote in message
news:slrnj875s3....@ID-685.user.individual.de...
>
OpenOffice.org?
--
Clif McIrvin
(clare reads his mail with moe, nomail feeds the bit bucket :-)
news:slrnj875s3....@ID-685.user.individual.de...
> On Wed, 28 Sep 2011 17:34:27 -0400, Douglas J Steele wrote:
>> 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.
>
> It's more than 64000 records and excel refused to open the file.
>> 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.
>
>
OpenOffice.org?
--
Clif McIrvin
(clare reads his mail with moe, nomail feeds the bit bucket :-)
Message has been deleted
David-W-Fenton
Sep 28, 2011, 7:20:36 PM9/28/11
to
Martin =?UTF-8?Q?=CE=A4rautmann?= <t-us...@gmx.net> wrote in
news:slrnj875s3....@ID-685.user.individual.de:
> On Wed, 28 Sep 2011 17:34:27 -0400, Douglas J Steele wrote:
number of rows.
--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/
news:slrnj875s3....@ID-685.user.individual.de:
> On Wed, 28 Sep 2011 17:34:27 -0400, Douglas J Steele wrote:
>> 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.
>
>> may be able to pull the data from Access, as opposed to pushing
>> it to a text file.
>
> It's more than 64000 records and excel refused to open the file.
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/
Albert D. Kallal
Oct 2, 2011, 6:29:05 AM10/2/11
to
"MartinΤrautmann" wrote in message
news:slrnj85icr....@ID-685.user.individual.de...
>Hi all,
>is there something like the mdbtools for Access 2007 format?
Just keep in mind, for at least the last about dozen years you could read
news:slrnj85icr....@ID-685.user.individual.de...
>Hi all,
>is there something like the mdbtools for Access 2007 format?
and extract and pull data out of an access mdb file without installing
anything on recent editions of windows.
>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.
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/details.aspx?displaylang=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
Pleasenos...@msn.com
Message has been deleted
The Frog
Oct 4, 2011, 5:20:33 AM10/4/11
to
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
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
David-W-Fenton
Oct 5, 2011, 1:24:26 PM10/5/11
to
Martin =?UTF-8?Q?=CE=A4rautmann?= <t-us...@gmx.net> wrote in
news:slrnj8hb2a.2...@ID-685.user.individual.de:
> On Sun, 2 Oct 2011 04:29:05 -0600, Albert D. Kallal wrote:
>> >Hi all,
>>
>> >is there something like the mdbtools for Access 2007 format?
>>
>> 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.
>
> databases. I don't.
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.
Message has been deleted
The Frog
Oct 6, 2011, 5:11:19 AM10/6/11
to
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
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
0 new messages