• Orfeo (5/5) Mar 11 2014 I should extract and process data from Microsoft Access database,
• dennis luehring (5/10) Mar 11 2014 "mdbtools is not enough"
• Orfeo (7/8) Mar 11 2014 ----->8-------
• dennis luehring (4/8) Mar 11 2014 answer the question
• Orfeo (20/21) Mar 11 2014 --------->8---------

"Orfeo" <orfeo.davia gmail.com> writes:

I should extract and process data from Microsoft Access database, 
and
mdbtools  is not enough.
Is there a library that I can use to query Access?
Thanks

dennis luehring <dl.soluz gmx.net> writes:

Am 11.03.2014 08:37, schrieb Orfeo:
 I should extract and process data from Microsoft Access database,
 and
 mdbtools  is not enough.
 Is there a library that I can use to query Access?
 Thanks

"mdbtools is not enough"

what is not enough?

what "version" of mdbtools do you use

https://github.com/brianb/mdbtools

"Orfeo" <orfeo.davia gmail.com> writes:

On Tuesday, 11 March 2014 at 07:52:33 UTC, dennis luehring wrote:
----->8-------
 what is not enough?

----->8-------
Thank you for github link, I had tried only with mdbtools on
http://mdbtools.sourceforge.net/...

So, it seems that I can connect using libmdb or odbc ... have you
any suggestions?

dennis luehring <dl.soluz gmx.net> writes:

Am 11.03.2014 09:06, schrieb Orfeo:
 Thank you for github link, I had tried only with mdbtools on
 http://mdbtools.sourceforge.net/...

 So, it seems that I can connect using libmdb or odbc ...

so everything is fine? or "I can not"

 have you any suggestions?

answer the question

what do you need?

"Orfeo" <orfeo.davia gmail.com> writes:

On Tuesday, 11 March 2014 at 08:22:40 UTC, dennis luehring wrote:
--------->8---------
 what do you need?

--------->8---------

Well, I should connect to result.mdb database and performs some 
queries, i.e.
    select * from result order by id
    select * from task where result_id=22
    ...
    select * from parm where task_id=256

then "merge" these records and export into json.

I am a D newbie, and  my plan is:
1. Create a bind to libmdb library (maybe with dstep)
2. Create D code than perform the queries and return record 
(represented in some way, array of struct, tuple...)
4. "Merge" the records
3. Convert these records into json files

Point 3. and 4. are easy, 1. and 2 hard to me ....

Another solution is convert (with mdb-export) mdb into CSV file 
and precess it, but I fear that "query" csv files it is very 
slow...