Once you create the append query,you run it.
After the import, & reconcile , run the append query in the macro.