build import event, or use macro

[sambucaman]

I import fresh data weekly from a xls into access 2003, curretly by going "File, get external data, import", and then selecting xls, and browsing to my file.

Is there a way to build an event that will automate this for me, once I click a button (much the same as i can send an email, or dial a contact) Or does this need to be a macro. I have never used a macro, nor (to be honest) do i know what they are / do.

Any advice on the best way to do this would be great. Thanks

 

[Mr. B]

A macro will do the trick to automate the import process. This just the thing that macros are there to do.

Take a stab at creating the macro. It is not that difficult and you should be able to get the import to take place quite easily.

Also, if you need to empty any existing data before importing the new data, you can have the same macro to do that also.

The other way to do this is with VBA code but that would require that you be able to write the code. The macro is much simpler to do.