original post here:
http://www.vbforums.com/showthread.php?t=581216

The DAO method that originally considered to be my resolution isn't working with excel 2007 workbooks. Anyone have any ideas on how I could get it to work with those or an alternate route?

Error:
External table is not in the expected format.