Okay, I tried again and what I noticed is that it populated the
qryDirectorsTotal and the qryCompaniesTotal but not the tblDirectors or
tblCompanies. So I know that I have definitely gone wrong here. When I
click on the Create tab and then click on QueryDesign it automatically comes
up with the Show Table window. For the qry's I chose the tblMyExcelStuff and
for the appends I chose the Queries tab and selected the qryDirectorTotal and
the qryCompanyTotal. Was I supposed to choose the tblMyExcelStuff or should
I have not chosen any of them and just pressed close and then went to SQL
view? They didn't automatically populate after clicking the Update
button....I had to click on the Run for it to even at least populate in the
qryCompaniesTotal and qryDirectorsTotal. I am sorry for the questions but
you have been so helpful and you are a very brilliant man for Access...so I
cherish your assistance but I understand if you have had enough of me.