How can I append/Insert/Update data to a table?
I have a table that 3000 records. Many of the records come from an Excel file so the "Source" field has a value of "Excel ss 2483". I would like to add a new record into another table (customerCodeIndex) for each record in the customer table that has a source = "Excel ss 2483". These new records will be just two fields: customerID and a customercode of "BASE"
My SQL should look something like this:
Insert into CustomerCodeIndex
Set CustomerCodeIndex.ID= Customer.ID, CustomerCodeIndex.CodeID = "BASE"
FROM Customer INNER JOIN CustomerCodeIndex ON Customer.ID = CustomerCodeIndex.ID
Where Customer.Source = "Excel SS 2483"
So far all Access wants to do is change existing records, I need it to add new records.
I have attached to images of my relationship table and my append query.