Append Query from Macro

[Guest]

Just getting my feet wet in Access and trying to figure out how to run an
append query from a macro. I have three Dbase files, May60.dbf, May90.dbf,
May120.dbf (obviously A/R aging files created by another application) that I
transfer in with a macro using the TransferDatabase action. I then want to
combine these three files into one table. It appears that using an append
query is the way to do this, but cannot figure out how to make it work within
a macro. Perhaps there is an easier way to combine these files? If so, I am
open to any suggestions.

 

[Guest]

You can run an Append Query by using the OpenQuery option in the macro and
then choosing your append query. Depending on your data, you may have to
delete the records before appending since it will not overwrite your data.
You can also turn the warnings off and on through your macro (make sure you
turn them back on again).

Hope this helps.