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

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

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?

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?

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...