Macros that Export Data Tables from Access to Excel

A

Annie

Hi,
For my coursework I have decided to create a macro that that exports data
tables from Access to Excel. I have managed top create one but it dosnt work
because ii is on an OLE network. Could youmplease tell me how to make it
work.

Also is it possible for this macro to executed in Excel? If that is not
possible then is it possible to create a macro in Excel that can import data
from Access?

Any help would be greatly appreciated,
Annie
 
Top