Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006

    Unanswered: Merging Two Tables

    I have a table with 1 to one relationship with the other. In retrospect, I don't think it was a wise move as I could easily used one table with combined number of fields in both tables. I now would like to create one table but would like to move data from table B to table A. Is there any easy way to combine tables into one, ie. moving records with respective field attributes from table B to table A. So effectively, fields will need to be created in table A.



  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    you could use an update query to transfer values from B to A, having created the new columns in tabel A

    the alterantive, and probably best, suggestion would be to use a make table query. then delete the old table A and remname the new table.

    have a look at the queyr types int he query designer
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2006
    Thanks Mark. I think the latter options is good. I did exactly that. Much appreciate your help.

Posting Permissions

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