Macros in Excel for Exporting Tables to Excel

Hi,

For my ICT coursework I have created a series of table in Access and I have decided to create a macro that exports the tables to excel. I have managed to create the macro but it will not work because it is on an OLE sever. Could you tell me how to make it work

Also would I be able to make this macro work when I am in Excel So I would have a macro button that exports data from Access, and it would be executed in excel.

If this was not possible, is there any way that I could create the macro in excel and import data from Access

Any help would be greatly appreciated.

Annie