I have two tables one labled raw data and the other sheet1. Both have the fields such as "software name", "vendor name", "software owner", and "software desc" and many more same fields. I need to update info from sheet1 into "raw data" on records where the software name mathces on both tables. I keep getting a zero records update error.


heres my query:
UPDATE RAW_DATA_BKUP_6_3_1457 INNER JOIN Sheet1 ON (RAW_DATA_BKUP_6_3_1457.COMMENTS = Sheet1.COMMENTS) AND (Sheet1.TRANSFER_REQ_COMMENTS = RAW_DATA_BKUP_6_3_1457.TRANSFER_REQ_COMMENTS) AND (Sheet1.BRIDGE_LENGTH = RAW_DATA_BKUP_6_3_1457.BRIDGE_LENGTH) AND (RAW_DATA_BKUP_6_3_1457.BRIDGE = Sheet1.BRIDGE) AND (Sheet1.COST_OF_MAINT = RAW_DATA_BKUP_6_3_1457.COST_OF_MAINT) AND (RAW_DATA_BKUP_6_3_1457.COST_TO_BUY = Sheet1.COST_TO_BUY) AND (Sheet1.TSA_TERMS = RAW_DATA_BKUP_6_3_1457.TSA_TERMS) AND (RAW_DATA_BKUP_6_3_1457.USAGE_NOTES = Sheet1.USAGE_NOTES) AND (RAW_DATA_BKUP_6_3_1457.LICENSE_AGREEMENT_STATUS = Sheet1.LICENSE_AGREEMENT_STATUS) AND (RAW_DATA_BKUP_6_3_1457.PAPER_AGREEMENT = Sheet1.PAPER_AGREEMENT) AND (RAW_DATA_BKUP_6_3_1457.CONTRACT_CONTACT = Sheet1.CONTRACT_CONTACT) AND (Sheet1.COPY_OF_AGREEMENT = RAW_DATA_BKUP_6_3_1457.COPY_OF_AGREEMENT) AND (RAW_DATA_BKUP_6_3_1457.PRIORITY = Sheet1.PRIORITY) AND (Sheet1.RISK = RAW_DATA_BKUP_6_3_1457.RISK) AND (RAW_DATA_BKUP_6_3_1457.TRANSFERABLE = Sheet1.TRANSFERABLE) AND (Sheet1.LICENSE_TYPE = RAW_DATA_BKUP_6_3_1457.LICENSE_TYPE) AND (Sheet1.QUANTITY = RAW_DATA_BKUP_6_3_1457.QUANTITY) AND (RAW_DATA_BKUP_6_3_1457.GE_ENTITY_ON_CONTRACT = Sheet1.GE_ENTITY_ON_CONTRACT) AND (Sheet1.LICENSE_CONTRACT_LOCATION = RAW_DATA_BKUP_6_3_1457.LICENSE_CONTRACT_LOCATION) AND (RAW_DATA_BKUP_6_3_1457.POLE_USING = Sheet1.POLE_USING) AND (RAW_DATA_BKUP_6_3_1457.BUSINESS_USING = Sheet1.BUSINESS_USING) AND (RAW_DATA_BKUP_6_3_1457.FUNCTION_USING = Sheet1.FUNCTION_USING) AND (RAW_DATA_BKUP_6_3_1457.SOFTWARE_DESC = Sheet1.SOFTWARE_DESC) AND (RAW_DATA_BKUP_6_3_1457.SOFTWARE_OWNER = Sheet1.SOFTWARE_OWNER) AND (RAW_DATA_BKUP_6_3_1457.VENDOR_NAME = Sheet1.VENDOR_NAME) AND (RAW_DATA_BKUP_6_3_1457.SOFTWARE_NAME = Sheet1.SOFTWARE_NAME) SET RAW_DATA_BKUP_6_3_1457.VENDOR_NAME = [Sheet1]![VENDOR_NAME], RAW_DATA_BKUP_6_3_1457.SOFTWARE_OWNER = [Sheet1]![SOFTWARE_OWNER], RAW_DATA_BKUP_6_3_1457.SOFTWARE_DESC = [Sheet1]![SOFTWARE_DESC], RAW_DATA_BKUP_6_3_1457.FUNCTION_USING = [Sheet1]![FUNCTION_USING], RAW_DATA_BKUP_6_3_1457.BUSINESS_USING = [Sheet1]![BUSINESS_USING], RAW_DATA_BKUP_6_3_1457.POLE_USING = [Sheet1]![POLE_USING], RAW_DATA_BKUP_6_3_1457.LICENSE_CONTRACT_LOCATION = [Sheet1]![LICENSE_CONTRACT_LOCATION], RAW_DATA_BKUP_6_3_1457.GE_ENTITY_ON_CONTRACT = [Sheet1]![GE_ENTITY_ON_CONTRACT], RAW_DATA_BKUP_6_3_1457.QUANTITY = [Sheet1]![QUANTITY], RAW_DATA_BKUP_6_3_1457.LICENSE_TYPE = [Sheet1]![LICENSE_TYPE], RAW_DATA_BKUP_6_3_1457.TRANSFERABLE = [Sheet1]![TRANSFERABLE], RAW_DATA_BKUP_6_3_1457.RISK = [Sheet1]![RISK]
WHERE (([Sheet1]![SOFTWARE_NAME]=[RAW_DATA_BKUP_6_3_1457]![SOFTWARE_NAME]) AND ([Sheet1]![SOFTWARE_NAME]=[RAW_DATA_BKUP_6_3_1457]![SOFTWARE_NAME]) AND ([Sheet1]![SOFTWARE_NAME]=[RAW_DATA_BKUP_6_3_1457]![SOFTWARE_NAME]) AND ([Sheet1]![SOFTWARE_NAME]=[RAW_DATA_BKUP_6_3_1457]![SOFTWARE_NAME]) AND ([Sheet1]![SOFTWARE_NAME]=[RAW_DATA_BKUP_6_3_1457]![SOFTWARE_NAME]) AND ([Sheet1]![SOFTWARE_NAME]=[RAW_DATA_BKUP_6_3_1457]![SOFTWARE_NAME]) AND ([Sheet1]![SOFTWARE_NAME]=[RAW_DATA_BKUP_6_3_1457]![SOFTWARE_NAME]) AND ([Sheet1]![SOFTWARE_NAME]=[RAW_DATA_BKUP_6_3_1457]![SOFTWARE_NAME]) AND ([Sheet1]![SOFTWARE_NAME]=[RAW_DATA_BKUP_6_3_1457]![SOFTWARE_NAME]) AND ([Sheet1]![SOFTWARE_NAME]=[RAW_DATA_BKUP_6_3_1457]![SOFTWARE_NAME]) AND ([Sheet1]![SOFTWARE_NAME]=[RAW_DATA_BKUP_6_3_1457]![SOFTWARE_NAME]) AND ([Sheet1]![SOFTWARE_NAME]=[RAW_DATA_BKUP_6_3_1457]![SOFTWARE_NAME]));


I also ran this select query but it keeps returing duplicates:
SELECT RAW_DATA_BKUP_6_3_1457.SOFTWARE_NAME, Sheet1.SOFTWARE_NAME, Sheet1.VENDOR_NAME, Sheet1.SOFTWARE_OWNER, Sheet1.SOFTWARE_DESC, Sheet1.FUNCTION_USING, Sheet1.BUSINESS_USING, Sheet1.POLE_USING, Sheet1.LICENSE_CONTRACT_LOCATION, Sheet1.GE_ENTITY_ON_CONTRACT, Sheet1.QUANTITY, Sheet1.LICENSE_TYPE, Sheet1.VERSION_INFO, Sheet1.TRANSFERABLE, Sheet1.RISK, Sheet1.PRIORITY, Sheet1.COPY_OF_AGREEMENT, Sheet1.CONTRACT_CONTACT, Sheet1.PAPER_AGREEMENT, Sheet1.LICENSE_AGREEMENT_STATUS, Sheet1.USAGE_NOTES, Sheet1.TSA_TERMS, Sheet1.COST_TO_BUY, Sheet1.COST_OF_MAINT, Sheet1.BRIDGE, Sheet1.BRIDGE_LENGTH, Sheet1.TRANSFER_REQ_COMMENTS, Sheet1.COMMENTS
FROM RAW_DATA_BKUP_6_3_1457 INNER JOIN Sheet1 ON RAW_DATA_BKUP_6_3_1457.SOFTWARE_NAME = Sheet1.SOFTWARE_NAME;