Updating entire tables using update query
Click this, it will change the select to a delete query...now click on the run (just the red Bang) I do this in two stages by hand just to be sure I have things correctly.One that will delete the offending records However, you haven't told us how you know which records to what to...It sounds like a Find Unmatched query might be needed to find the records that are in import_adv and aren't in tbl_adviseurs to know which ones to append. hi zmdb, How i know which records to add, delete or modify ? I set the primary key not to the ID but ot the field NR_adv.You need to select the option so that are returned and the matching records from "tbl_adviseurs". now right click the line and select the option to (of course, in the sql view this will be all on one or two lines.) and Bob's Your Uncle, you should be done.If you do not have this relationship then you need to create this relationship (left click and drag [import_adv]! Once these queries are running correctly, you can automate the process by creating either VBA or Macro code to call each query... This will however only work when you haven't defined relations to the NR_adv field.
by checking the grid table values and the 3 table id's which all are specified as identification as yes.We then update the matching data in the local target table by using a join with the temporary table. Copyright© Geeks No portion may be reproduced without my written permission.Software and hardware names mentioned on this site are registered trademarks of their respective companies.Fields in the qyery; - Segment - Zip - TEL - AM - AD However it does not append the new records to the existing database and it does not delete records that are not in the "import_adv" table How can i make sure that new records in the import_adv table are appended tot the tbl_adviseurs ?How can i make sure that records that are deleted in the import_adv table are also deleted from the tbl_adviseurs ? Pierre You'll need at least two queries One that will update and append the records of interest.
This is the number we give to a "adviseur" and is unique.