It's perhaps a little off-topic as this is a Gambas mailing list, but I have written a .mdb to mysql|postgresql|hsqldb|mssqlserver converter in java. I tried using mdbtools but never got very satisfactory results, so I wrote my own conversion software.
The converter works on Northwind (the sample .mdb from MS), including the binary pictures and on our own database we use for stock control at work (150,000 records or so, takes about 5 mins...). There is support for complete conversion of the schema (create all tables, columns with null/not null, create primary keys, indexes, foreign key relations, ...) and of course, the all-important data! I'm looking to test against a few more databases, so if this is an interesting route to follow, don't hesitate to contact me directly. I also support a kind of basic "interactive mode" through a socket where you can retrieve rows, do simple selects, examine columns etc. The conversion is done using only commands which are also available as interactive commands... Kind regards, Caveat On 27/08/13 10:32, Fernando wrote: > On Aug 26, 2013 21:34 "Willy Raets" <wi...@earthshipbelgium.be> wrote: > >> I made a small example project that makes a connection to a .mdb >> >> This is how it is possible (I only tested the connection, not reading >> in >> tables or changing any records): >> >> > perhaps you missed my initial email, that's what I did based on an older > email on this list. The problem is, apparently, not the connection but > the retrieving of data. > > Regards, > Fernando > ------------------------------------------------------------------------------ > Introducing Performance Central, a new site from SourceForge and > AppDynamics. Performance Central is your source for news, insights, > analysis and resources for efficient Application Performance Management. > Visit us today! > http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk > _______________________________________________ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > ------------------------------------------------------------------------------ Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user