VBA Excel Code to Insert New Record into MS Access Database

Forgive me for being such a newbie on these kind of things. I've got some really neat code running in Excel VBA which automates several engineering tasks. One of the last things I need to do is to collect some of the data in the Excel file and insert it as a new record in an MS Access database. Can VBA code in Excel do this?

It surely can.

Okay, you are certainly right. A quick search and I found this code to do the task:

Please Login or Register  to view this content.

And viola...it works perfectly. Now I have another snippet of code that I'm working with in VB.NET. It looks into the database and performs an SQL command to get the highest number in the DwgNo field. It adds one (+1) to that and returns the value to be used so that when the new record is added, the next sequential number for this field is also added.

Please Login or Register  to view this content.

I'm assuming (correctly, I hope) that this code will not work in VBA. Can anyone help me with how to modify this code so that I can do basically the same thing. That is to find the highest value in the DwgNo field, add 1 to it and then return this value so that when I commit the new record to the database I can include this new sequential number?