DAO 3.6 doesn't load all "tables"

[Ralph]

I'm updating an app that was originally written by someone
else in VB6. The app originally used DAO 3.51 and worked
fine, but as nobody had those ISAM drivers, I switched it
to DAO 3.6. The problem now is that only a single "table"
loads from the xls file rather than all (18) of them. The
only difference I noticed was that using DAO 3.51, the
Database.Version property was "5.0" (for an Excel file
created in Excel 2002). In DAO 3.6, the Database.Version
property was "8.0" (for the same file). The TableDefs
property only contains the first table when using DAO 3.6,
but DAO 3.51 loads all 18 of them. I saved the xls file
as a 95/5.0 version and it works (DAO 3.6 sees it as a
version 5.0 file and loads all of the tables), but it
losses some of the necessary features of the file, so that
isn't really an option. Also, in the OpenDatabase call,
I've tried passing in "Excel 5.0" and "Excel 8.0", and
even though the connection shows the value I passed in,
the Database.Version is not affected by this setting. If
anyone has any ideas on how I can get DAO 3.6 to read in
all of the tables of an Excel 2002 file, I'd greatly
appreciate it. Also, switching to ADO is not an option
due to project constraints.