New to SQL but here is what I have:

Current tickets are in a excel sheet (Sheet3 or Current Cases depending on how you refer to it in excel objects) it is based on columns with the ticket number as the header

What I want to do:

1. When the sheet is updated compare columns to another sheet (Sheet5 or Archive depending on how you refer to it in excel objects)

2. Update any existing columns in Sheet5/Archive with the new information from Sheet3/Current Cases

3. Insert any new columns from Sheet3/Current Cases
into Sheet5/Archive

4. Not lose old columns in the archive sheet if they do not exist on the current case sheet.

I am using the following:

SELECT S1.A, Iif(IsNull(S2.A),S1.B,S2.B)
FROM [Sheet3$] as S1
LEFT OUTER JOIN [Sheet5$] as S2 ON S1.A = S2.A

and get Sheet3$ is not a valid name.

Can I get some guidance here.

T.Hanks

-Sam