Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Append Query (2003)

    Hi,

    I have a employee table & system login information table in my database. The relationships between those two tables are one to one. Before I create the database, those information are store in a excel file. I have import the excel file into my database as a table. Now I want to append the table (includes employee & system login information) from excel file data to two tables (employee & system Login information). How should I do it?

    I did try to create a query to have all the fields from employee & system login information table. So I can use append query to append data, however the append query only can append to table, not query.

    Thanks

    Regards

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Append Query (2003)

    Hello Gary,

    You'll have to create two append queries: one to append some fields from the Excel table to the employee table, and one to append other fields from the Excel table to the system login information table. You cannot do both in one query.

    Note: in general, I try to avoid one-to-one relationships. It's much easier to store the information in one table, and if you have too many fields for one table, it's time to rethink the design.

Posting Permissions

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