Importing tables using a macro

[PowerPoint Jedi]

Hello,
First of I am using Access 2003 and am self taught (spoken not to good at
it)

As stated in the title I am trying to make a macro to import tables in order
to make a report I run easier for other people to use. Can this be done. If
so how?

Thanks for taking a look at this

 

[Jeanette Cunningham]

Hi,
create a new macro.
Choose TransferDatabase as the action.
Fill in the details in the lower pane of the macro design that supply
details of the table, the source and destination databases.
On the same macro, include enough TransferDatabase actions with details to
import all the needed tables.

Jeanette Cunningham