Appending existing table

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I have tbl1 with a list of names and numbers, then I set
the primary key in tbl1(autonumber). I have created an
append query2( tbl2) with the same tbl1 structure. I am
linked to SQL2k with 1 tbl "name". In the append query I
have 2 tbls in that query2, name and tbl1. I am trying
extract data from agent that is not in tbl1 and want to
append tbl1. Is this possible? even with null fields?
 
List the structures of the tables involved.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top