I want to export data from an excel worksheet into an
existing access table. I can do this using the convert to
access option in the data menu but I would like to do it
with a macro. (Recording doesn't work). Does anyone know
how I can do this?

Thanks

Carl