Database Wizard

Hello,

If someone could help i`d be most grateful.

I have made a small database in Access and now want to import data into it using excel. I made a template for the database which works every time i press the save button. The problem is this. I`m writing a macro that will automatically input the data from a file into the database using the wizard but when i run the macro with the activeworkbook.save comand nothing is put into the database but click on save and a templete wizard appears with the options of updating the database or cancelling.

Any suggestions how i can get round this.

Many thanks

James