I posted the question below in the Queries group but have not yet received
any feedback.  I'm trying to import data from another database via an append
query.  It seems this is the logical method, but having never done this, I am
starting out struggling a bit.  Please read my previous post.  Feedback is
greatly appreciated!!

- Previous post -
I have never used an append query, but need to import multiple fields across
4 tables from another database.  Based on some previous postings, I have
determined that I will create a macro to first link tables using the
TransferDatabase action, then run an Append Query to pull gather the desired
data and add it to the destination tables, then run the DeleteObject Action
to eliminate the links.  All of the properties of the destination tables
match the source database as they are required to.

Because I have never created an append query, I tried to create the query
with just 2 fields.  In design view, I added the linked table, which renamed
itself from "Project" in the source database to "qryImport1" in the
destination database.  From that I selected 2 fields:  JobNumber and
ProjectName.  The field names are the same in both databases.  When I
selected Append Query and the Append To box popped up, I selected my
destination table which is called "tblProject".

So down below in the design grid I show the following 2 fields:

Field:  JobNumber
Table:  qryImport1
Sort:
Append To:  JobNumber
Criteria: "065812"  (This is the JobNumber that I want the recordset for.  I
will be referencing a control on a form eventually.)

Field:  ProjectName
Table:  qryImport1
Sort:
Append To:  ProjectName
Criteria:

When I view the query in datasheet view or run it, the JobNumber data reads
065812 as it should, but I get "tblProjectProjectName" as the data in the
ProjectName field.

What might I be doing wrong?
Thanks in advance for any help!