Merging 6 of the best

[rolfrobinson]

I have 6 excel sheets all of which are the same format ie name, address, Tel etc plus a unique number, job status and an install date.

I have linked the six excel sheets into my database. (They are in excel because that is how i recieve them via email from someone using MS Access and they cant do anything about it.)

I have all my data in one table, but I have to do 6 queries to compare the data between the 2 different types of table and excel sheets.

Can anybody explain a simpler way so that i can reduce the no of queries and merge all six excel sheets together with out having to cut and paste.

The main reason why i havent done an append and update query is the fields have dynamic data which changes every week. plus I thought there may be a simpler way of doing it.

I am an access newbie so if you can explain this simply so i can understand i would be grateful.

thanks in advance

 

[Mile-O]

How about a UNION Query?

 

[rolfrobinson]

How about a UNION Query?

Im not too good with SQL and I cant seem to relate my database to the quotes on Access help. i have tried before to do a union query but it kept giving me errors.

Do you know of any websites which would help me to learn SQL for access, so that I might have a better idea of what I should be writing?

Or any other language I should learn first to help with my programming language skills.

Thats how much of a newbie I am........

 

[Mile-O]

w3Schools has an SQL tutorial here as well as some other languages.

 

[rolfrobinson]

Thanks for the website it made for some interesting reading. And made things a lot clearer to me!!

I have got an example table and sheet to merge using a union query but on the original it just kept saying syntax error.

Is this because when i have done the original links they had spaces between the words on the linked table name??

Is that why it wouldnt work originally?

thanks again for your help now hopefully i can sort out my work!!
have a good weekend

 

[Mile-O]

If you have spaces in table or field names in access then surround them with square brackets.