swamyvnvs - 2010-04-02 05:02:35
Hi,
Thanks for that.
But in the site 'http://bryanmills.net/archives/2003/11/microsoft-access-database-using-linux-and-php/' it has mentioned some limitations that
As of the time of writing this entry MDBTools did not support write access to the mdb files. This was fine for my purposes as I was reading data in and sticking it into a mysql database.
- There is a bug in MDBTools v0.5 which does not allow you to query tables or columns with an underscore. This was a bug I hit early on, but it has been fixed in new version 0.6 but that has not been released as of the time of writing this article. So I recompiled the 0.5 source code with the fix from the 0.6 CVS repository. I have bundled it into a 0.5 release and have the two rpms mentioned above here:
mdbtools-0.5-1.i386.rpm
mdbtools-odbc-0.5-1.i386.rpm
I would check the official download site before using my hacked version as I’m sure this bug will be fixed in 0.6 (plus rumor has write access will be present as well).
But my reauirement is to insert or update the data in mdb files.
May you please reply me soon.
Thanks & Regards.