Hi

the 2 totals queries don't "run" as such. You should be able to just open
them.

Open the companies 1st and make sure you companies are showing - you should
see just one of each.

Go to the companies table and delete all the record just to make it simple.

So you should be able to your companies in the companies total query ?
The should be nothing in the new companies table.

Click run on companies append and it should add the companies from your
import table from ecel to the new table and allocated each an ID.

If this is working do the same with the directors.

Let me know if its working.

If not I will create an email account some where - can you zip the file as
most e mail accounts will allow access db's unless zipped (I think)



--
Wayne
Manchester, England.



"pupkiss1965" wrote:

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.