Excel as a front end to an Access database

[BillE]

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

 

[Dick Kusleika]

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.

Executing SQL statements in a ADO Connection object is the way I do it. So
if that's what you read, then I don't think there's anything new that you've
missed. However, using Access as the front end saves a lot of coding.