Macro Function explained

[Jay]

I need help writing a macro that will retrieve data from a table in one
database and update a table in another database. Can someone help me with
this?

 

[Tom Lake]

I need help writing a macro that will retrieve data from a table in one
database and update a table in another database. Can someone help me with
this?

Link the table from the other database and then use an Update Query
to do the updating. No need to write a macro.

Tom Lake