[AccessD] Excel from Access (COM) - Need to read all rows in all sheets

[Brad Marks]

All,


I experimented with Access/Excel via COM a couple years ago.


I now have been given a large Excel file that has many sheets.  I need to read each row in each sheet.


Does anyone have a example of how to do this?


Thanks,

Brad