How to use excel as database and what is the syntax for querying.Im using ODBC excel driver and the connection is successful but im unable to retrieve the value.
Read up about the Excel COM object. It will give you all the help you need.
Also, check out the search function here. This has been discussed many times.
If this or any response has helped you, please reply to the thread stating that it worked so other people with a similar issue will know how you fixed your issue! Ciege...