www.digitalmars.com         C & C++   DMDScript  

digitalmars.D.learn - Interface to Microsoft Access database (Jet)

reply "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
Mar 11 2014
parent reply 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
Mar 11 2014
parent reply "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?
Mar 11 2014
parent reply 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?
Mar 11 2014
parent "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...
Mar 11 2014