Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jul 2004
    Thanked 0 Times in 0 Posts

    Update Query (2k)

    I'm using an update query to try and update my main table from a linked excel table. The main table and linked excel table have the same feilds. I tried changing the query type to update query, and where it says update to: i put '[Drawing Table]![Drawing Number]' (which is my main table) expecting the main table to be updated when the query was run. However when i run it, i get a Enter Paramater Value prompt. Are update queries not used for this purpose? or am i just doing something wrong?
    <img src=/w3timages/blueline.gif width=33% height=2>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Update Query (2k)

    An update query is used to modify existing records. If you want to update an Access table from a linked Excel table, you must add both to the query, and join them on a field (or combination of fields) that uniquely identifies the records.

    An append query is used to add records from one table to another. In this case, you would base the query on the linked Excel table. when you select Append Query from the Query menu, you will be asked to specify the target table.

Posting Permissions

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