KevEarthwatch
Technical User
I am running an append query with a nested "find unmatched". it is intended to append entries from one table (a linked excel form) to another local copy of the table, keeping both identical.
When i run the query i receive the following error message: "The INSERT INTO statement contains the following unknown field name: "ANONYMOUS(1=YES)". Make sure you have typed the name correctly, and try the operation again."
When i go into the SQL to simply copy and paste the field name over itself (there are no visible differences) and then run the query again, i get no error message.
I would think that the (1=YES) part has something to do with it, but cant figure why i wouldn't receive the error message after essentially altering nothing in the SQL.
I also get the same error message for the RESTRICTED(1=Yes) field. These field names are from an external database source which the linked excel file is reading from are it is easiest to leave them alone if possible. This error message only recently started popping up.
Here is the Query SQL:
INSERT INTO [Copy Grants] ( [GRANT NAME], [GRANT ID], [ANONYMOUS(1=Yes)], [COMPANY NAME], [CONTACT ID], [DONOR TYPE], [ED GRANT TYPE], [FIELDING GRANTED], [FIELDING TARGET], [FIRST NAME], [GRANT SUB-TYPE], [GRANT TITLE], [GRANT TYPE], [LAST NAME], minimum, notes, [OVERHEAD GRANTED], [OVERHEAD TARGET], [RESTRICTED(1=Yes)], restrictions, source, [SOURCE DESCRIPTION], [START YEAR], [TOTAL GRANTED], [TOTAL TARGET] )
SELECT [Copy Grants].[GRANT NAME], [Copy Grants].[GRANT ID], [Copy Grants].[ANONYMOUS (1=YES)], [Copy Grants].[COMPANY NAME], [Copy Grants].[CONTACT ID], [Copy Grants].[DONOR TYPE], [Copy Grants].[ED GRANT TYPE], [Copy Grants].[FIELDING GRANTED], [Copy Grants].[FIELDING TARGET], [Copy Grants].[FIRST NAME], [Copy Grants].[GRANT SUB-TYPE], [Copy Grants].[GRANT TITLE], [Copy Grants].[GRANT TYPE], [Copy Grants].[LAST NAME], [Copy Grants].minimum, [Copy Grants].notes, [Copy Grants].[OVERHEAD GRANTED], [Copy Grants].[OVERHEAD TARGET], [Copy Grants].[RESTRICTED (1=YES)], [Copy Grants].restrictions, [Copy Grants].source, [Copy Grants].[SOURCE DESCRIPTION], [Copy Grants].[START YEAR], [Copy Grants].[TOTAL GRANTED], [Copy Grants].[TOTAL TARGET]
FROM [Copy Grants] LEFT JOIN Grants ON [Copy Grants].[GRANT ID]=Grants.[GRANT ID]
WHERE (((Grants.[GRANT ID]) Is Null));
When i run the query i receive the following error message: "The INSERT INTO statement contains the following unknown field name: "ANONYMOUS(1=YES)". Make sure you have typed the name correctly, and try the operation again."
When i go into the SQL to simply copy and paste the field name over itself (there are no visible differences) and then run the query again, i get no error message.
I would think that the (1=YES) part has something to do with it, but cant figure why i wouldn't receive the error message after essentially altering nothing in the SQL.
I also get the same error message for the RESTRICTED(1=Yes) field. These field names are from an external database source which the linked excel file is reading from are it is easiest to leave them alone if possible. This error message only recently started popping up.
Here is the Query SQL:
INSERT INTO [Copy Grants] ( [GRANT NAME], [GRANT ID], [ANONYMOUS(1=Yes)], [COMPANY NAME], [CONTACT ID], [DONOR TYPE], [ED GRANT TYPE], [FIELDING GRANTED], [FIELDING TARGET], [FIRST NAME], [GRANT SUB-TYPE], [GRANT TITLE], [GRANT TYPE], [LAST NAME], minimum, notes, [OVERHEAD GRANTED], [OVERHEAD TARGET], [RESTRICTED(1=Yes)], restrictions, source, [SOURCE DESCRIPTION], [START YEAR], [TOTAL GRANTED], [TOTAL TARGET] )
SELECT [Copy Grants].[GRANT NAME], [Copy Grants].[GRANT ID], [Copy Grants].[ANONYMOUS (1=YES)], [Copy Grants].[COMPANY NAME], [Copy Grants].[CONTACT ID], [Copy Grants].[DONOR TYPE], [Copy Grants].[ED GRANT TYPE], [Copy Grants].[FIELDING GRANTED], [Copy Grants].[FIELDING TARGET], [Copy Grants].[FIRST NAME], [Copy Grants].[GRANT SUB-TYPE], [Copy Grants].[GRANT TITLE], [Copy Grants].[GRANT TYPE], [Copy Grants].[LAST NAME], [Copy Grants].minimum, [Copy Grants].notes, [Copy Grants].[OVERHEAD GRANTED], [Copy Grants].[OVERHEAD TARGET], [Copy Grants].[RESTRICTED (1=YES)], [Copy Grants].restrictions, [Copy Grants].source, [Copy Grants].[SOURCE DESCRIPTION], [Copy Grants].[START YEAR], [Copy Grants].[TOTAL GRANTED], [Copy Grants].[TOTAL TARGET]
FROM [Copy Grants] LEFT JOIN Grants ON [Copy Grants].[GRANT ID]=Grants.[GRANT ID]
WHERE (((Grants.[GRANT ID]) Is Null));
