By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,264 Members | 1,100 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,264 IT Pros & Developers. It's quick & easy.

Conditionally Append Rows...is it Possible?

P: 1
Hey guys!

I have a problem. I am currently working on a project where I am required to look through a couple Databases (originally from Foxpro). One is a full contract list (roughly 2100 rows), the other is one huge database of all the members and the contracts they are committed to only (almost reaching 500,000 rows).

My question is this, Is there a way to run an Append query that can check the member contracts and what they are committed to, and then compare it against the full contract list. If the Contract from the full list is not in the member contract committment list, then add it to that database.

I hope this is possible, I've been racking my brains thinking of the logic involved. Seems simple, but committing it in the language is harder. Will I have to use VBA script with SQL?

Any help is appreciated, thanks alot!
Jun 13 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Hey guys!

I have a problem. I am currently working on a project where I am required to look through a couple Databases (originally from Foxpro). One is a full contract list (roughly 2100 rows), the other is one huge database of all the members and the contracts they are committed to only (almost reaching 500,000 rows).

My question is this, Is there a way to run an Append query that can check the member contracts and what they are committed to, and then compare it against the full contract list. If the Contract from the full list is not in the member contract committment list, then add it to that database.

I hope this is possible, I've been racking my brains thinking of the logic involved. Seems simple, but committing it in the language is harder. Will I have to use VBA script with SQL?

Any help is appreciated, thanks alot!
To help with this we will need the metadata of the tables involved.

Here is an example of how to post table MetaData :
Table Name=tblStudent
Expand|Select|Wrap|Line Numbers
  1. Field; Type; IndexInfo
  2. StudentID; AutoNumber; PK
  3. Family; String; FK
  4. Name; String
  5. University; String; FK
  6. Mark; Numeric
  7. LastAttendance; Date/Time
Jun 15 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.