Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2005
    Posts
    36

    Question Unanswered: Help with Append Query

    Hello there.
    I have a Master file with a price field that needs to be updated. There are currently close to 2000 records, while this can be done manually one record at a time, I need to see if this can be automated.

    We have an excel file with the Master file key number and the corresponding price.
    example
    Master Table
    BomId (Table Key)
    Price

    Excell sheet (this sheet has the actual price)
    BomId
    Price

    I have imported the contents of the excel sheet into a temporary Table with the exact same fileds, I need to update the Master file from this temporary table.
    I have used update queries in the past so this is not new to me, but in this case where I have the key field in both Master table and temporary table, just cant get it to work.

    I hope I did a decent job of explaining myself, and hope someone out there can help.

    thanks in advance
    Carlos

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Not Append query, but Update query.
    Look at "DemoQueryUpdateA2000.mdb" (attachment, zip).
    Look at tables, Query1Update, Relationships.
    Run Query1Update and see.
    I think it is what you need.
    Before take a copy of your table.
    Attached Files Attached Files

  3. #3
    Join Date
    Jun 2005
    Posts
    36

    Thumbs up

    You are right MStef, wrong post heading, I ment to say Update.
    Anyway, thanks for your reply, it did work, the only change I had to make is from One to Many, to One to One relationship.

    Again, thanks for you help,
    Carlos

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •