I have ste up code to export excel data to a table in access 2007. It works
in Access 2003 but not 2007. The following extract fails with the message
"Run-Time Error '3343'. Unrecognized database format "C:\Documents and
Settings\Peter\My Documents\NEMS\Databases\Backends\NEMS Members_be.accdb"

Dim db As Database, rs As Recordset, r As Long

Set db = OpenDatabase("C:\Documents and Settings\Peter\My
Documents\NEMS\Databases\Backends\NEMS Members_be.accdb")

It seems that DAO and access 2007 don't mix!