Access importing problems

Discussion in 'Databases' started by blwire, Jul 22, 2008.

  1. #1
    Hey i have a access db setup and am having trouble appending a table. Table A has email, first name and last name. Table B has the rest of the info and they 2 are linked by the first and last name. How do i get the emails into table B with the right names and other fields associated with them? Ive been messing with append queries for hours and cant figure it out :( Thanks for the help.
     
    blwire, Jul 22, 2008 IP
  2. sscheral

    sscheral Peon

    Messages:
    24
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    using inner join you can fetch the details from both table
     
    sscheral, Jul 24, 2008 IP
  3. WatchCount.com

    WatchCount.com Active Member

    Messages:
    27
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    86
    #3
    May I ask: why not have both data sets in 1 table? I guess maybe you need more than 1 row in Table 2 for each person in Table 1? If that's not true, and you have a 1-to-1 relationship between each row in T1 and T2, then make it easier on yourself and have it all in 1 table.

    That said, I don't think you can use Append Queries to add to more than 1 table at a time. Maybe you don't need to, and you're aiming for T2.

    How do you have the 2 tables joined in the Relationships area? Did you make a primary key of 2 fields (first+last name)? That should work, but consider using an ID# instead, for better efficiency.

    In the Append Query, it sounds like you're fiddling with getting the right criteria. You may need to use some functions or DLookUp's, but as I'm alluding to above, your challenges might be eliminated by simplifying your DB structure from the start.

    Hope that helps....
     
    WatchCount.com, Jul 30, 2008 IP