I read Iczelion's ODBC tutorial, it uses MS Access(mdb) database format. I tried to convert the source code to make it work with excel files. But i failed.
Could anyone help me with this?

Posted on 2010-04-20 02:21:32 by hakand
ODBC access should be independed from the underlying database.

Make sure, that you have installed a valid ODBC driver for excel tables and check if you can access this ODBC source with some other tool, e.g. Microsoft "RowsetViewer" which is part of the free Microsoft Platform SDK.

With help of that external tool you can also check if all the commands you are using, are supported by the Excel ODBC driver.
Posted on 2010-04-21 06:01:53 by beaster