Template Data to Database

I have created a template and database and here is what I would like to accomplish.

Currently, after entering data into the template I would select Save from the file Menu Excel will allow me to Create a New Record from the Template File - Save to Database Dialogue Box. Then I would click on the Create a New Record option and the Save As Screen pops up. I would have to click cancel and Select from File New to create a new record again.

What I would like to do is:
After entering data in to template, I would like a macro to export the current data to the database file and bypass the Save As Screen and then have a blank new record (template) ready for data entry again. If possible leaving the data from the previous screen intact for editing (some records are alomost identical from one to the next except for minor changes).

Basically to explain it simply, I would like a macro activated by a button that sends the current data from a template screen to a database everytime you press it.

Thanks for any help.

John