-
Need assist with sheet naming and probably other issues as well
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules