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;
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;
