Results 1 to 3 of 3

Thread: Appending????

  1. #1
    Join Date
    Dec 2003
    Location
    Bahrain
    Posts
    1

    Cool Unanswered: Appending????

    Hi guys,

    I am appending a data from a single field table into a table with multiple fields and I received an error "microsoft access can't append all the records in the append query..." and it did append the specific data...

    Can anybody help me?

    Thanks & regards.



    Table1; with following fields [Field1]
    Table2; with the following fields [Field1], [Field2], [Field3]...

    Here's the SQL code

    UPDATE Table1 INNER JOIN [Table2] ON Table1.Field1 = [Table2].Field1 SET [Table2].[Field1] = [Table1].[Field1];

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    You can't do that ... Updates can only occur on a single table ...

  3. #3
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    And of course if the initial field is blank sometimes you'll want to make sure that the target field allows blanks.
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

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