Appending existing table

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?
 
M

[MVP] S. Clark

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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append table with If then else 2
recursively retrieve records from 2nd table based on records from 1
Add records via query in a one-to-may relationship 2
Append Query Assistance 5
Ignore Leading Zeros in Mixed Alpha-Numeric Text Fields Select Query 5
Append Query Help Needed 10
Append Query Assistance 1
Append Querry, Key Violations, AutoNumber? 1

Top