Is this possible? I assume I need an ODBC driver or other recognised from Excel/Query to access Base.
I don't think it is possible, at least not easily. OO Base is a front end that actually uses HSQLDB as its database engine. There is this thread in the OO community forum where a workaround is proposed to unzip your .odb file and use JDBC to connect to the HSQLDB database. (I haven't tried this). The OO forum thread is a bit old, so it might be a good idea to try to find alternatives.