The Client currently is using Excel for data storage.

They want to continue using Excel front end for data entry, but store the
data in an Access database.

I have googled lots of information about using VBA DAO/ADO to implement such
a solution, much of which appears to have changed little from Access 97.

I wondered if there are new features in Access 2007 to assist in this
process. I don't much like Access 2007 because of the lack of toolbars,
menubars, and Access security, but I would be interested if there are
advantages I haven't realized yet.

The VBA code I have found should work fine, but I don't want to overlook any
better solutions which I haven't stumbled over in google.

Thanks
Bill